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
Best answer by PaulKortmanView original
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.
Actually the sheets will have more than 300 rows 😪
Thanks for your help !
Thanks a lot
So I need to learn to code now :-) in order to write the script