How do I create a new Google Sheet from a Template (eg. another Google Sheet)?

Status: Closed · Asked by Anders Nielsen on · 0 views

Anders Nielsen — Question ·

Currently trying to migrate some of my Zapier zaps to Pabbly and I can't seem to find that function in Pabbly Connect.

It seems I can kind of do this but I need two steps:
1. Create Spradsheet
2. Copy Spreadsheet

The problem is:
A. I then waste a task (a minor problem).
B. The bigger problem is that Pabbly names the copied sheet "Copy of ABC".
C. Finally I get an extra sheet that is not needed (because I'm forced to create a new sheet when I create a new spreadsheet).

If the Sheet is named ABC I want the copied sheet to also be named "ABC". How can I rename it then and how do I get rid of the empty sheet?

Fagun Shah — Reply ·

Have you tried Google Drive action - > Copy a File , it might help.

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/
Anders Nielsen — Reply ·

Wow! Thanks a lot @Fagun Shah ! Don't know why I missed that action. Not only did this solve the problem. It reduced the number steps required as well ?

Back to all forum threads · Log in to reply