Subscribe to my channel to receive updates about this series: 🔔 tchflw.ai/yt-subscribe How often do you use Google Sheets? - I use it AT LEAST daily. 😅
@pksteITАй бұрын
how can, with integromat to insert in a cell some text with a part of this in italic.... like... Ciao mondo .... sheet don't transform the value in html....
@shafiqzukriАй бұрын
HI there, can i know, can we modify the data first before insert to the new row? Let say i have sample data "Blue" from webhook. Then i wanna change the value before insert the data to my google sheet to "Success". Vice versa, if the value is "Red" then "Fail" inside the sheet. Is It possible? Hope you notice me. Thanks
@TechflowAIАй бұрын
Great question and great use case for the Make functions. :) This is how you can make it work: In your Google Sheet module, in the text field right where you want to enter the final data, add a Make function called switch(). As the input, map your variable of the webhook with your sample data. I'll call it "input". switch(input;......) Then as first parameter of the switch() function use Blue and as value you want to switch to use Success. switch(input;Blue;Success;....) Repeat the same process for any other potential value you want to switch, like Red and Fail. switch(input;Blue;Success;Red;Fail;....) The last parameter is your "ELSE" condition. So if your input parameter doesn't match Blue, nor Red, it would go to the else - let's say OTHER: switch(input;Blue;Success;Red,Fail;OTHER) That's your final function. For your conveniene, simply copy and paste this into your text field and maybe update the input variable: {{switch(1.input; "Blue"; "Success"; "Red"; "Fail"; "OTHER")}} If you want to learn more about functions - check out or free Make functions cheat sheet where we explain this function + all others in high detail with examples: tchflw.ai/Make-Functions-Cheat-Sheet Cheers, Manuel
@AshrafTheVoyager Жыл бұрын
What are the correct integromat scenarios for receiving a worksheet from email then automatically adding some formula columns to that worksheet to generate an updated worksheet at the end?
@TechflowAI Жыл бұрын
You'd need to use Google Drive to store the file, then search the rows/columns with the Google Sheet modules and finally download the file again with Google Drive module. Hope it helps!
@chrisder181421 күн бұрын
hello could you explain to me why there are two ways to connect Google sheet with make? I realize that the first method is the Google sheet extension to connect make to it but there is a second way it is make there is a Google sheet node
@TechflowAI20 күн бұрын
For sure: The Google Sheet extension is used to send an instant notification to Make whenever you're doing manual changes to your Google Sheet. You can limit it to certain ranges/columns. That is the only purpose of that extension. On the other hand, within Make you can establish a connection to Google Sheets to do all sorts of other fun stuff. Searching, adding, updating rows and a lot more. That connection is necessary so Make is authorized to work on Google Sheets on behalf of you. Hope that helps! Let me know if you have any further questions. Happy automating, Manuel
@chrisder181420 күн бұрын
@TechflowAI ok thank you very much for your answer, however I still don't understand, could you tell me some examples and use cases So that I can understand why should I install the make addon in Google sheet or install the Google sheet module in make could you give me examples, use cases so that I can understand and also do you do e-commerce on WordPress and Marketplaces like Amazon and eBay? I'm asking you this question because I understood that with the woocommerce module from make I can automatically post my listings from my Google sheet database to woocommerce? can I do this with other Marketplaces? Or do I have to install product feed extensions?
@TechflowAI20 күн бұрын
Thanks for your question! The Make add-on on Google Sheets is only used for 1 module (Watch new rows) on Make. You can ignore it for now. Just use the regular connection within Make to connect to your Google Sheets and do whatever you want. Yes, you can connect any Marketplace that has an API to your Google Sheet via Make. For example: Google sheets - search rows > WooCommerce - create product That way you can sync it easily to WooCommerce from your sheet. Hope this helps! Remember, at Techflow.ai, we’re here to help you produce more time. 🌟 Manuel
@chrisder181414 күн бұрын
@@TechflowAI can I send you an email?
@TechflowAI11 күн бұрын
@@chrisder1814 sure! Feel free to reach out at info@techflow.ai
@maybeyoureright43347 ай бұрын
is there a way to trigger a new scenario with the creation of a new sheet it google sheets?
@TechflowAI7 ай бұрын
Yes, that's possible. You'd need to leverage Google Apps Script for that. ChatGPT can provide you exact step-by-step instructions to set it up with Apps Script. The script would fire a Webhook to Make whenever a new sheet is created with the details of that new sheet. Unfortunately, there isn't a module in Make that allows for direct achievement of that.
@maybeyoureright43347 ай бұрын
@@TechflowAI thank you!
@TechflowAI7 ай бұрын
@@maybeyoureright4334 you're most welcome! :)
@maybeyoureright43347 ай бұрын
@@TechflowAI So, I would then create a webhook trigger in a scenario using a URL from the Apps script?
@TechflowAI7 ай бұрын
Almost. You're using the webhook trigger in a scenario an put the URL of that webhook trigger into the Apps Script code.
@denisminko40082 жыл бұрын
Thanks so much for such a valuable video! Btw, is there a way to use integromat for creation of conditional formatting rules in sheets?
@TechflowAI2 жыл бұрын
Thank you very much! Glad it helps. There is no pre-existing module to do that but the Google Sheets API allows you to set up conditional formatting. That being said - you could use the "Make an API Call" module to access that API endpoint and configure it yourself: developers.google.com/sheets/api/samples/conditional-formatting
@alexanderdanylenko95435 ай бұрын
What if the search returns results and you can see them, but in the next step, they're empty and it says empty ID?
@TechflowAI5 ай бұрын
That sounds like there is an error somewhere. Feel free to reach out to me and we can jump on a quick zoom call to check it out. info@techflow.ai
@wilsonrondini79302 жыл бұрын
If you have a table in a google sheet where the headers are not the top row how would you populate the table underneath that. For example say you have a table in cells D16:H:30. You want to populate those rows with data. How do you do that? I can only seem to get the top rows to populate.
@wilsonrondini79302 жыл бұрын
Kazam. Got it. I have the first row of the table as a static number. Then I use update row and an increment function tool to update the rows. Boom. Nice I'm a good 10% done. That was a fun hour and a half to figure out.
@TechflowAI2 жыл бұрын
@@wilsonrondini7930 Good job finding a workaround! :) That's not 100% dynamic, so I suggest using a method that I explain in Part 03 of this Google Sheets series: kzbin.info/www/bejne/qWWYk4Wea91siKs "Keep Formulas" will be what you need here. Also, the batch updates could be very handy too. Let me know if that helps!
@user-ph1vy3pu3b10 ай бұрын
Is there a way to do a Vlookup of sorts between 2 Google Sheets via Make? I have values in one file that I need to transfer to another based on another column value.
@TechflowAI10 ай бұрын
Yes, that's doable. Use the "Search Rows" module for Sheet #1 to find the value you want to look up on Sheet #2. Then add another "Search Rows" module right afterward and use your lookup value from Sheet #1 inside the filter to check if the value exists in Sheet #2. If found, you can use the "Update a Row" module to copy the value from Sheet #1 to Sheet #2 into the respective row. Does that make sense?
@user-ph1vy3pu3b10 ай бұрын
It does. What if though I don't have a header in the sheet I want to copy into?@@TechflowAI
@akhilvv61292 жыл бұрын
is that any option make an automation for each comment in terllo card create a task in todoist?
@TechflowAI2 жыл бұрын
Yes, you can use the "Watch Activities" module of trello to kick off your automation. Creating a task on todoist will be straight forward then.
@avv9662 жыл бұрын
@@TechflowAI thank you 😊 it’s working now
@TechflowAI2 жыл бұрын
@@avv966 Awesome! Great to hear. 💪
@jeremymurphy7475Ай бұрын
I have tried 1,000 ways.... How can I get a Google Sheet to convert into a JSON with the Sheet Headers in the json and NOT the 0,1,2,3????? I am suer you can spit this out in seconds...... thx
@TechflowAIАй бұрын
Good question! You want the headers as keys and the rows as values inside an array with 1 item per row? Ist that correct? Or what is your desired output exactly?
@jeremymurphy7475Ай бұрын
@@TechflowAI the elements of the json show 0"name"; 1"size"... and so on... I need: name:"jason", Size"small"... make sense?
@TechflowAIАй бұрын
Are you using the search rows or search rows (advanced) module?