Skip to main content

Been struggling with this one…

I have an excel file that is generated multiple times a day into a Google Drive.

 

I want to pick that up and load all rows into a Zapier Table.  Seems like it should be easy, but I am struggling.

 

Anyone have tips?

Hi @Raleigh Fingers,

 

Welcome to the Community.

 

To automate data transfer from a Google Drive Excel file to Zapier Tables, start by creating a Zap. Set Google Drive as the trigger with the "New File in Folder" event and connect your account. For the action, choose Google Sheets, select "Create Spreadsheet Row(s)," and map the columns to the data from your Excel file. After testing, turn on the Zap to ensure data is automatically added to Google Sheets. Since Zapier lacks direct integration with Zapier Tables, use Google Sheets as an intermediary, then manually import the data into Zapier Tables.

 

Let us know if this helps you jump-start your process.


Reply