Unlock the Power of Google Sheets with Make.com: Advanced Automation Secrets Revealed

[@gestordetrafegopago]

Hello Mitch! Thanks for your video. I have a scenario similar to this one, but in my case, I would like to update the registration and not create another line. Example: look for the contact, if it exists, update the entry date, otherwise register it.

[@NoCodeAutomators]

To update instead of creating a new line you must store and search for a unique identifier, this could be an email or phone or id - if found then update, if not found then create new record.

[@chrisder1814]

hello I have several ideas for automation regarding SEO and also image editing, but I would like you to tell me what you think about it

[@NoCodeAutomators]

Sounds exciting! SEO and image editing can be powerful with automation. Bubble.io and Make.com are great tools for this. Dive in, experiment, and share your progress. We're here to help! 🚀

[@chrisder1814]

@MitchBaylisBusinessAutomation ok thank you very much could I send you an email

[@chrisder1814]

@NoCodeAutomators could I send you an email?

[@chrisder1814]

@@NoCodeAutomators could I send you an email

[@chrisder1814]

@@NoCodeAutomators hello, could I send you an email

[@glendertravel496]

Thanks for the video. How do you duplicate the same spreadsheet and still keep the same values in the extension? When I duplicate, I need to write the values manually.

[@NoCodeAutomators]

This is not possible in make, but it might be if you write a google script to do it. I'd recommend hiring a google script expert to do that since it requires quite a bit of specialized coding knowledge.

[@eftihisbotonakis7204]

I have a Google sheets watch rows trigger and it’s skipping past empty rows. As far as I know that’s not how it’s supposed to work? Is there any way around this?

[@NoCodeAutomators]

well technically the empty rows have not been changed from their default value and so there is no data to "watch" so it won't trigger the watch for those rows - which is exactly how it's intended to work. if you want it to trigger for the empty rows you could add and remove data to the row, that'll trigger it, but you have to change the row value to trigger the watch - else use the search rows module

[@rebeccavesperas8274]

When you're using an acid trigger that is supposed to trigger instantly (like for example when a new row is added in a google sheets spreadsheet) but you have the scenario set to run once a day how does that work? Also, it's not clear where the link to the free course is. I'm very interested but which one is the link?

[@NoCodeAutomators]

When you set the scenario to run on a scheduled start then the acid trigger will capture and hold all the events that would have triggered it and then it'll batch process them when it is scheduled to run. mitchbaylis.com/free-make-automation-course/

[@nadiasouza7194]

Hey Mitch. Thank your for your videos. I just want help with google sheets and integromat. I want to pick a random row (text from a row) and send it to the telegram bot. Not able to get to it. Could you help

[@NoCodeAutomators]

This will be pretty straight forward with google sheets. First you need to create a random number - there's a function in integromat to do that it's called "random" and returns a decimal value so you'll have to multiple it to a whole number and then round it. Then in google sheets you'll need to number the rows in a column and then use that column to search by to find the row.

[@vickyfrank5001]

Hi Mitch is there a way to convert a complete data from csv to google sheet in integromat the csv file is from an https request

[@NoCodeAutomators]

Well you'd probably want to iterate the csv using the csv module in make and then create a row in gsheets for each csv row - that's one way to do it. You could also do it in bulk, bulk create the rows but that's fairly advanced and would require custom integration to gsheets api - so not something I'd recommend unless you're regularly importing thousands of rows. Alternatively, depending on the csv source you could use a google script to keep google sheets synced to your source data base - again this would be fairly advanced, but you could hire it out on fiverr for someone to code it for you for about $20 usd. It would require that the source database has a decent api.

[@guillermoguzman6425]

Thank you very much for your videos, I wanted to ask you how I can automate a Google Sheets cell that contains a formula and take the value to another cell of another Google Sheets. Thank you again

[@NoCodeAutomators]

You will need to copy the formula from that cell into the cell you want to map that formula to. When you do this in integromat you will need to change the row numbers that the formula is referencing. Depending on the formula the row number may or may not need to change.

[@maryamahmedseager142]

Hi Mitch! Thanks for this video. What is the best way to search multiple sheets in a google spreadsheet for a value? I have different product SKUs in different tabs (sheets) in the same spreadsheet and I need to search all sheets to look for a specific value and then return that value.

[@NoCodeAutomators]

You'd need to do a search module for each sheet, OR you could use the switcher module to switch between sheet IDs and a repeater module to repeat the search module with the different sheet ID. For method 2 you'd have to make sure the data is in the same columns each time otherwise it won't work. Alternatively, you could also just create a merged sheet using gsheet formulas and then just search that 1 sheet. To capture the record ID you'd use a variable and a filter, if row ID exists, write to variable, when variable exists, stop repeating the search of the sheets and move on to next step.

[@stlr5127]

Hi Mitch! Many thanks for your video. In my integromat scenario I need to update many spreadsheets that are numbered by month like 2201, 2202 etc. Now I want the google sheet module to choose the spreadsheet automatically by its number (as a string). But it returns an error "not found". Interestingly this "choosing by string" in the integromat module works for sheets. Why not for spreadsheets?

[@NoCodeAutomators]

Spreadsheets use the spreadsheet ID, whereas the sheet uses the sheet name as the identifier. A workaround may be to store the spreadsheet names and IDs in a database (integromat data store) and then reference that data to find the correct spreadsheet ID. Otherwise you could use google drive search module to find it by the name - but that'd be less reliable.

[@stlr5127]

@@NoCodeAutomators Thx a lot. But google/integromat could make it a little bit easier ...

[@clappedbycris]

Hello, do you have a video covering the topic of how to send multiple cells in one email? I have a function that updates and captures the info from a row and sends it as an emaoil and text message, my only problem is that the system sends the same row over and over instead of moving to the next row. Could you help me with this?

[@NoCodeAutomators]

You would want to use a search/list rows module and then the scenario would send an sms for each row - or if you wanted all the rows in 1 sms you'd then use an aggregation module to combine them (aka a text aggregator).

[@geraldpaolodarsantos8452]

How to delete entire rows with array formula?

[@NoCodeAutomators]

It's a bit hard to answer this question as I don't have all the information needed, but I would imagine you need to iterate through the array and then lookup the array id property in the gsheet to get the row, then you can delete the correct row for each item in the array.

[@ym-wv4zy]

Hello Mitch! Thanks for your video. May I ask if I'm gonna sync the value from Sheet 1 and Sheet 2 to Sheet 3, which means in Sheet 3 will contain the values of both Sheet 1 and Sheet 2, what is the best practice to do so? Do you have any idea? Thank you in advance!

[@NoCodeAutomators]

Depending on what you are syncing you would possibly be better off using a google sheet lookup formula across the sheets rather than integromat. By the sound of it you probably want to create more of a relationship database, in which case AirTable might be better for you than gsheets.

[@unTLDR]

Dude... Drop your upsells into an area which doesn't break the flow of the lesson - rookie training tip 101. Otherwise, great content

[@NoCodeAutomators]

It's all about testing. I test a whole bunch of different methods and each video has a unique bitly link which enables me to track exactly which videos/methods convert the best. All this data gets sent to a datastudio report that I review once a month - you are right though, the videos that convert the best are those without upsells in them. The issue with youtube is that I cannot replace a video once it is posted (not without losing the views and SEO) - I have to upload an entirely new video. So even though a bit annoying I will leave this one up. You'll notice the new videos do not have upsells breaking the flow :)

[@Haidar20ali]

Can you help me plz i have 30 clients everyone has a deferent Expire day and I wanna send alert Message on WhatsApp for each one (1 day) before Expired day. Thank you 🙏🏻

[@NoCodeAutomators]

You need to store these dates in a database somewhere, something like airtable or googlesheets, or even the data store module in Make. Then you'd have a scenario checking this list of dates daily and if one matchs then it sends the whatsapp message and deletes the data or marks it as being sent.