Question

Zapier to copy data inside an Excel file in GDrive (1 sheet) and paste the data in another file (GSheet with multiple sheets)

  • 1 August 2020
  • 1 reply
  • 104 views

Hi Everyone. Hope U are fine ?

New on Zapier. Trying to build an automation using Zapier-Excel-Googlesheet-Parabola to end in Geckoboard

I'll try to explain my need :

  • My trigger : each time the user saves an Excel file (1 sheet) in GDrive with a specific name (eg 01 for January, 02 for February...12 for December)
  • Can Zapier open the file - copy the data - paste the data in a specific GSheet in the relevant sheet based on the name of the trigger file (07 in the trigger-→ copy the data in the 07 Gsheet sheet) ?

Thanks and enjoy u're WE

Daniel


1 reply

Userlevel 7
Badge +8

Hi @Daniel_Clementine!

I looked into this for you but I don’t think this is going to be possible. There’s a bit of flexibility when it comes to Google Drive copying files and with Google Sheets copying worksheets, but not quite in the way that you’re looking for. 

Can I ask how many rows these sheets would tend to have? If more than 20 rows I don’t know that there’s a way to accomplish your workflow.

@ikbelkirasan can you think if any clever workarounds here?

Reply