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

Part 01 is all about the concept of using Google Sheets as a database for automation.

Get more information here 👇

0:00 - Introduction
0:34 - How to Automate Google Sheets
1:17 - Walkthrough of Available Modules
3:11 - Set Up Sample Scenario Concept
5:21 - Iterator and Aggregator Video
6:01 - Set Up - Add a Row
7:57 - Set Up - Update a Row
9:36 - Full Run and Concept Explanation

Finally Master RegEx? - Check out our Ultimate RegEx Bootcamp 👇
(The LAST time you'll wonder - wth is RegEx?!)

################################

[TechflowAI]

Subscribe to my channel to receive updates about this series:

How often do you use Google Sheets?
- I use it AT LEAST daily. 😅

[maybeyoureright]

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

[Ottoleads.ioiAAA]

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

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

[blogger]

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?

[MichaelChorley]

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.

[denisminko]

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

[chrisder]

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

[pksteIT]

how can, with integromat to insert in a cell some text with a part of this in italic.... like... Ciao <em>mondo</em> .... sheet don't transform the value in html....

[wilsonrondini]

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.

[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

[akhilvv]

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

[alexanderdanylenko]

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

[jeremymurphy]

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 I am suer you can spit this out in thx