How to copy one Google Sheet to create a new Google Sheet
Status: Open · Asked by Jeff Bianchi on · 0 views
I have a Google Sheet named "Onboarding". This sheet has multiple worksheets (tabs at the bottom). Each worksheet has many rows.
I want to create an Action steps that copies the "Onboarding" sheet and creates a new sheet, named from mapped data coming from the trigger app. The new sheet should have all the same worksheets (tabs at the bottom), with the same names as the original sheet.
I can't see a way to do this in Pabbly Connect.
Can you help?
Hi @JeffB,
You can setup your workflow in this manner to achieve your use case.
https://connect.pabbly.com/workflow/share/WBADMVYBAWJVHwhiAlEFIgoeBgIJUwg1AxpURldYUioGSAFUUBELYQhEWHoHVAVkAksJYwVZAz4PG1JWAlQCcVxGVHgAAwB6AE0GfVAzW2hYBgMrVjc#
Please note that a blank sheet will be created in each of the newly created spreadsheets; there is no workaround for that.
Oh wow. That's not acceptable at all. Zapier does this with 1 task -- no matter how many worksheets there are. Plus, all the tabs have their original names, not "Copy of....".
How do I request that the Pabbly 'Copy Google Sheet" integration be changed to behave exactly like Zapier's?
Currently, that's the only possible way to achieve your use case. If you want changes to an existing application/action step you can submit your request on our dedicated platform: https://pabbly.featureos.app/b/Update-Existing-Application
Oh wow. That's not acceptable at all. Zapier does this with 1 task -- no matter how many worksheets there are. Plus, all the tabs have their original names, not "Copy of....".How do I request that the Pabbly 'Copy Google Sheet" integration be changed to behave exactly like Zapier's
Just use Google Drive Copy File action to copy the template gsheet.