Best Google Sheets Automation Tips with Make.com (formerly Integromat) (Part 01)

[@TechflowAI]

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!

[@chrisder1814]

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

[@TechflowAI]

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

[@chrisder1814]

@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?

[@TechflowAI]

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

[@chrisder1814]

@@TechflowAI can I send you an email?

[@TechflowAI]

@@chrisder1814 sure! Feel free to reach out at [e-mail]

[@maybeyoureright4334]

is there a way to trigger a new scenario with the creation of a new sheet it google sheets?

[@TechflowAI]

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.

[@maybeyoureright4334]

@@TechflowAI thank you!

[@TechflowAI]

@@maybeyoureright4334 you're most welcome! :)

[@maybeyoureright4334]

@@TechflowAI So, I would then create a webhook trigger in a scenario using a URL from the Apps script?

[@TechflowAI]

Almost. You're using the webhook trigger in a scenario an put the URL of that webhook trigger into the Apps Script code.

[@denisminko4008]

Thanks so much for such a valuable video! Btw, is there a way to use integromat for creation of conditional formatting rules in sheets?

[@TechflowAI]

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

[@alexanderdanylenko9543]

What if the search returns results and you can see them, but in the next step, they're empty and it says empty ID?

[@TechflowAI]

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. [e-mail]

[@wilsonrondini7930]

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.

[@wilsonrondini7930]

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.

[@TechflowAI]

@@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-ph1vy3pu3b]

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.

[@TechflowAI]

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-ph1vy3pu3b]

It does. What if though I don't have a header in the sheet I want to copy into?@@TechflowAI

[@akhilvv6129]

is that any option make an automation for each comment in terllo card create a task in todoist?

[@TechflowAI]

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.

[@avv966]

@@TechflowAI thank you 😊 it’s working now

[@TechflowAI]

@@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?