Importing multiple sheets from Google Sheets into Zapier tables

Hey ​@Hlaubs,

I do think so you would have to import sheets separately. Here is a helpful article about importing data into Zapier Tables- https://help.zapier.com/hc/en-us/articles/19693186435853-Import-data-into-Zapier-Tables. Hope it helps!

i think no needs to do this

Thanks ​@Sparsh from Automation Jinn ! I will do so today. Not too many sheets 😆. Have a good day.

Yes, currently Zapier Tables can only import one sheet at a time, so you’ll need to import each of your 15 sheets separately into new tables. Alternatively, you could combine all sheets into a single master sheet in Google Sheets and import that, then filter or organize data within Zapier Tables.

You can effectively manage your data workflow by combining all disparate data sources into a single, unified spreadsheet and synchronizing it with your existing tables. This approach offers a streamlined method for data integration and management.

Yes. You’ll need to import each sheet separately. Zapier Tables, as of now, treats each table as an independent dataset, much like a single sheet in Google Sheets. There isn’t a native bulk import feature that automatically brings in all sheets at once. So if you have 15 sheets, you’ll create 15 corresponding tables. It’s a bit manual, but it ensures each dataset remains structured and clean for automations. The good news is, once imported, your tables become far more powerful than static spreadsheets. You can automate workflows, trigger actions, and connect data across apps effortlessly. Think of this as setting the foundation right before building your automation system.  

Imagine you have 15 notebooks, each with its own pages of notes (these are your Google Sheets).
Zapier has 15 boxes called Tables, and each box can only hold one notebook at a time.

You can’t pour all 15 notebooks into one box. it’ll get messy.
So you take each notebook, open it, and carefully copy its pages into its own box.

After that, Zapier’s magic starts. it can make your boxes talk to each other, send notes to apps like Gmail, or even make automatic updates every time you write something new.

So yes, one notebook (sheet) → one box (table). Once you do that, you can teach Zapier to connect them however you like.

Many thanks ​@IsabellaThomas345  and ​@paul3331  - I’ve never thought of doing it that way. Though I’m not sure if I I should do it.

Some background: I run a very small charter service, just to fetch my clients’ kids from boarding schools to homes towns and back to school again. Of all my tables only 1 is actually a working table, and that is the Trips table. The clients (Parents), passengers (Children), Schools, Bus Stops etc. all simply provide peripheral data for Trips. A Parent books a Child for a weekend’s trips and basically only selects a direction (Home/School/both). All other info for the bus lists/schedules with pickup and drop-off times and places are either looked up from the other tables or calculated. So the ETA for drop-off on Friday would be the last pickup time at school - i.e. time leaving for the bus stops - which is calculated from the manually entered school pickup times, plus the driving time to each bus stop, which is looked up from the Bus Stops Table.

In my current app these calculations are all done in table columns, but Zapier has Global Variables which is one of the reasons I’m moving 👌.

So I have imported my data now - very easy!. One thing I noted was if I import from a Sheet, the field order is all over the place; but when importing from a csv the fields stayed in the same order. Weird.