Sync Google Sheets to Airtable using Integromat

[@dalankerr]

Thank you so much for posting this, it is EXACTLY what I needed in combination with your 2-way sync video :D

[@BusinessAutomatedTutorials]

You're so welcome!

[@danceindia]

Hi, Thank you for the nice tutorial. I am wondering how do you delete if rows are deleted

[@BusinessAutomatedTutorials]

In this case you would have to use a different approach. Instead of identifying fields in Airtable based on their name (stored in first key column), you would have to add fixed row numbers in Airtable. You could create a fix number for a row using Auto-number field type. This way each row would have a fixed row number similar to row number in Google Sheets. Integromat trigger from Google Sheets returns row numbers of changed fields - which you could use to identify which rows in Airtable have to be update or cleared ( content of all cells apart from row Auto-number would be cleared). Let me know if this answers your question?

[@ChandrikaShenoy-m2v]

Thank you for this. I tried this approach and it works for one cell change at a time. Is there a way to tweak the Make scenario for bulk updates? So say I have two columns of which one has fixed values and for the second column, I copy paste 10 rows at a time. I want the corresponding 10 rows in airtable to be filled as well. Currently using the approach you have mentioned above, I am able to update one change or one row at a time. What tweak would be needed for bulk updation ?

[@BusinessAutomatedTutorials]

If you copy paste data in bulk it will also trigger update for each row affected. You could alternatively use schedule approach - run a function to update data to Airable every X hours, but it will always run for each row. Not sure if that is what you were aiming at?

[@mahmoudbedeir4141]

Hello, thanks for this informative tutorial! I've one question, how can I get 2 or more records in airtable from one row in google sheets.

[@BusinessAutomatedTutorials]

You would put multiples Create Airtable Record modules in a chain so that based on one row of data from Excel you generate for example 3 records in Airtable (eg. in Order Table, Customer Table and Delivery Table)

[@staceywhite5826]

Are there any updates to this, struggling to get this to work. If I paste new rows in my Google Sheets, it only copies the first row. I noticed AirTable has different options now, since this video. Thank you for any updated info!! 🙂

[@BusinessAutomatedTutorials]

The principles should be similar as the core concept did not change.

[@shareami9045]

Hello and thanks for this tutorial ! I've done every steps, it seems to work alright in integromat, but the changes don't appear in my Airtable, would you know where the problem comes from ? Thank you very much for your answer

[@BusinessAutomatedTutorials]

What is the output visible in the bubbles on Airtable module during execution in Integromat? If there is data coming in to Airtble incorrectly it would throw and error. Maybe mapping of fields should be checked?

[@miguel_pinto_0]

And If I want to delete a row how can I do that, what will be the filter that i could put

[@BusinessAutomatedTutorials]

That is bit trickier - you would have to put an action "Delete" and have a fliter reacting to it and executing delete in Airtable.

[@agoogleuser6937]

What if we use the airtable ids as primary key (vlookup/watch field)?

[@BusinessAutomatedTutorials]

You will have to keep a column for that in Google sheet as well.

[@DS-ig1bf]

Very helpful thank you. I would love to see the next level to this, creating Airtable Tables synced to multiple sheets in one GoogleSheet. My Airtable Base has mutliple tables in order to create different data types, Person, City, Organization, each have their own table. Would I need to create different webhooks for each sheet?

[@BusinessAutomatedTutorials]

You can! Once you add the Integromat/Make webhook extension to your Google Sheet Document it monitors updates on all sheets. The data arriving in Airtable will have "Sheet1" or "Sheet2" and etc. This way you could filter the data to different Airtable tables.

[@TheAjw26]

Thanks for the great tutorial, but I cannot turn on my integromat for automatic scheduling. There is an issue with the bundle validation which ends the process. I have structured my data in the same way and have set up the scenario in the same way but I am now sure how to solve this error. Please can you suggest what might be the issue? Thanks in advance 🙏🏽

[@BusinessAutomatedTutorials]

Which module throws the error?

[@BusinessAutomatedTutorials]

and what is the description of the error?

[@digital-Marketing-barcelona]

Great thanks for sharing this, it is just what I was looking for :)

[@BusinessAutomatedTutorials]

Glad it was helpful!

[@MrAjayen]

Hello Business Automated. I really enjoy watching your videos on Integromat gives me a broad knowledge about the application . I am wondering if there is a way to make Integromat watch multiple google sheets at once and update the data from a specific cell or column? I am really curious to know 😀

[@BusinessAutomatedTutorials]

There are 2 approaches to that depending what frequency of update sync you need. If this needs to be instant than the "Watch Rows" and "Watch Changes" triggers are the way to go. You could specify to react to changes in only specific row /column and make Integromat ignore any other changes. In this case for each watch trigger (for each Sheet) , you would need a separate scenario Another approach would be to use "Search Rows" or "Get Range Values" in a scheduled scenario ( that runs example every 5 or 10 min) to check for a specific value. In this case you could have multiple Search Rows modules in single scenario if you need to check for example 5 sheets in the same time.

[@MrAjayen]

Thanks a lot for your quick response. Let’s say I am want to get a specific data from 5 different google sheets document and post and creat a reporting message in skype or slack or any messenger application. Here I do not want to create 5 individual scenarios as it is not effective when it comes to number of operations. So I will need a single scenario to watch all the 5 Google Sheets and this will Be scheduled to work twice a day I.e morning and evening. Please advise :)

[@BusinessAutomatedTutorials]

In this case second option would work best would be to start with "Array iterator" containing IDs of the 5 different sheets as start and "Search Rows" as second module and the rest the way as you want to set it up.

[@MicaelaMotta]

Can you make a tutorial using uosert record as the last option instead of the router?

[@BusinessAutomatedTutorials]

Yes, at the time video was made there was no upset option. It could certainly work instead of router if else scenario.

[@vinzdegar]

Thanks!

[@AlessandroEren]

lEGEND!

[@geraespinosar]

can you make a tutorial for sync sharepoint items to airtable, for users with microsoft solutions already T_T ?

[@BusinessAutomatedTutorials]

Hi! Great idea. I will need to check my my office 365 account and see what I can do. Do you want to sync files or do you want sync data from Excel?

[@geraespinosar]

@@BusinessAutomatedTutorials Sync data definitely please, because me and my team already use power apps at the work. Cheers

[@thejorgemarques]

Hi great tutorial, I actually changed the Google Sheet to Airtable also, just different table, but I get same error all the time: Cannot initialize the scenario because of the reason 'Flow is empty and contains no configured module' Scenario initialization failed with an error. Thank you very much.

[@BusinessAutomatedTutorials]

Have you added the Integromat plug in in Google Sheets? The error is showing up inside of Integromat? Have set Google Sheets as the first module with little lightning icon on it?

[@Sammiebuilds]

⚠HELP: I get an error whenever I update the entire row on my Google Sheet at once. Is there a fix for this? "Error [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text." Thank you for putting this video here for free, you just gained a new follower.

[@BusinessAutomatedTutorials]

This: "Error [422] The formula for filtering records is invalid: Invalid formula. Please check your formula text." Means you have an error with your Airtable module and the formula you have inserted there is not valid. Best way to test is create that formula in Airtable first, check if it returns a correct value - if yes add in the make module.

[@mkvhoqnuncdotfwqumbm845]

text

[@BusinessAutomatedTutorials]

Number

[@BusinessAutomatedTutorials]

which text? Don't keep me hanging bro!

[@comp2477]

great. thank you

[@BusinessAutomatedTutorials]

Welcome 😊