Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi, I’m trying to figure out how to add a step in one of my workflows between Google forms and Google sheets.

The trigger is a new Google Form submission.  I need to add a step where a worksheet from the excel file that is uploaded in the Google form is copied into an existing Google Sheet template.  The problem is that I can’t copy the worksheet that was created with the Form submission since Forms just refers to it as a Google Drive link.

Hopefully that isn’t too confusing but I’ve got most of the workflow completed but can’t figure out how to add this crucial step. 

Thank you.

Hi @crestkid! 

 

Can I check I’ve understood what you’re trying to do here? Your Google form has a file upload field where folks are uploading an Excel file and you want to be able to copy that file into a Google sheet, is that right? If that’s the case then it’s not possible to do it that way as there’s not a way to directly access the information in the Excel file to copy it to a Google Sheet. 

 

That said, I think that there’s a workaround here. If you ask the people adding the file to the form to save the file as a .csv rather than .xls file, then you will be able to get the contents of the file to then send it to Google sheets.

 

To do that, use the Formatter app and choose Utilities > Import CSV file. Then use the action Google Sheets Create Spreadsheet Row(s), which can create rows using the line items that you’ll get. from the Formatter step. 

 

 

Hi @crestkid!

I just wanted to check in with you to see if you’d managed to get things working using the suggestion by @Danvers, or whether you could still use some help here. Please let us know :)

Terms & Conditions