Skip to main content

Hello everyone,

I have a Google Sheet with multiple tabs, including one main tab called DATA which is updated at regular intervals. The other tabs in the sheet rely on this DATA tab using IMPORTRANGE and other formulas, so I can’t isolate or split it into a separate sheet.

My goal is to sync the DATA tab into Airtable, ideally in near real-time, so changes in Google Sheets reflect automatically in Airtable.

The problem I’m facing is:

  • Airtable’s direct import only works with single tab Google Sheet.

  • I cannot split or isolate the DATA tab into a new file, as it will break all dependent tabs using formulas.

Has anyone successfully set up a sync in this kind of setup? I’d appreciate recommendations

  • Access a specific tab from a Google Sheet

  • Keep the sync live or near real-time

  • Avoid restructuring the original Google Sheet

Thanks in advance!

To setup a continual sync between multiple tabs in Google Sheets and Airtable, you would need to use a 3rd-party integration tool.

I personally prefer using Make, but there are tons of other tools out there as well.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Terms & ConditionsAccessibility statement