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 all! I need a way of copying data from one google sheet to another. However, it must only be the numerical values within the sheet that are copied, and not the formulas that are generating them. 

A Zapier staff member has said this isn’t possible using the standard ‘copy sheet’ action, and there is not another way of doing it in one step. So I’m putting it out to you! I’m open to finding a less direct solution (ie potentially: exporting sheet as .csv file, then re-importing into google sheets?) - does anyone have any thoughts?

Thanks very much!

Hi @mungle88 

Your workaround sounds plausible. If you do a “Google Drive - Find File” step and get it to find your Google Sheet, you’ll see one of the (many) URLs you get back from that is the download link for a CSV version of that file.

What you could then do is use a “Formatter->Utilities→Extract CSV” step - passing in the URL as the input value - to get those line items out and then a “Google Sheets->Create Spreadsheet Row(s)” (« make sure to pick the plural version of the action step), to write the rows back to a Google Sheet.

Thanks Andrew, I’ll give this a go

Terms & Conditions