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. 😅
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.
how to search columns instead of row? Let's say I have A-Z numbers 1-20... how do I find the column with the number 17 and change values underneath this column?
Unfortunately that's not possible directly. Google Sheets is based on rows. You can get ALL rows though and then reformat the data with an Array Aggregator and filters to get the Row IDs and the data of column number 17 out. Then update one row at a time within that column to change the values.
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.
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?
That's not possible. It will always add a new row after the FIRST row that is empty. So if you have blank rows in between it will insert it there. Would that be a workaround?
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
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
@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?
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
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?
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!
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.
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.
@@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: th-cam.com/video/s45bRh6x9RI/w-d-xo.html "Keep Formulas" will be what you need here. Also, the batch updates could be very handy too. Let me know if that helps!
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....
Unfortunately that's not possible (easily). There might be pretty complex workarounds via API but I'd suggest using a different tool like SmartSuite or Airtable if you need that formatting. tchflw.ai/SmartSuite tchflw.ai/Airtable
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
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
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
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
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?
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. 😅
powerful stuff man, thanks
Thank you! :)
You're most welcome
is there a way to trigger a new scenario with the creation of a new sheet it google sheets?
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.
@@TechflowAI thank you!
@@maybeyoureright4334 you're most welcome! :)
@@TechflowAI So, I would then create a webhook trigger in a scenario using a URL from the Apps script?
Almost. You're using the webhook trigger in a scenario an put the URL of that webhook trigger into the Apps Script code.
how to search columns instead of row? Let's say I have A-Z numbers 1-20... how do I find the column with the number 17 and change values underneath this column?
Unfortunately that's not possible directly. Google Sheets is based on rows.
You can get ALL rows though and then reformat the data with an Array Aggregator and filters to get the Row IDs and the data of column number 17 out.
Then update one row at a time within that column to change the values.
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.
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?
It does. What if though I don't have a header in the sheet I want to copy into?@@TechflowAI
Awesome, can i add a row to a specific row Number? I'd like to inserta my data in a specidyc row and not only at the bottom
That's not possible. It will always add a new row after the FIRST row that is empty.
So if you have blank rows in between it will insert it there.
Would that be a workaround?
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
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
@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?
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
@@TechflowAI can I send you an email?
@@chrisder1814 sure! Feel free to reach out at info@techflow.ai
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?
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!
is that any option make an automation for each comment in terllo card create a task in todoist?
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.
@@TechflowAI thank you 😊 it’s working now
@@avv966 Awesome! Great to hear. 💪
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.
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.
@@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:
th-cam.com/video/s45bRh6x9RI/w-d-xo.html
"Keep Formulas" will be what you need here.
Also, the batch updates could be very handy too.
Let me know if that helps!
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....
Unfortunately that's not possible (easily).
There might be pretty complex workarounds via API but I'd suggest using a different tool like SmartSuite or Airtable if you need that formatting.
tchflw.ai/SmartSuite
tchflw.ai/Airtable
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
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
Thanks so much for such a valuable video! Btw, is there a way to use integromat for creation of conditional formatting rules in sheets?
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
What if the search returns results and you can see them, but in the next step, they're empty and it says empty ID?
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
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
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?
@@TechflowAI the elements of the json show 0"name"; 1"size"... and so on... I need: name:"jason", Size"small"... make sense?
Are you using the search rows or search rows (advanced) module?