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.

Best answer

Copy a Google Worksheet from a "template" Google Sheet ?

  • January 20, 2020
  • 3 replies
  • 294 views
Scendre

I'm trying to figure out how to create a new worksheet with some headers with styling (bold, center, bg color and dropdown menu).

My main idea was to copy a worksheet from another Google Sheet reference but I can't find it in the list.

I can't copy the whole Google Sheet document as I already have some informations in it.

Do you have any clue on how I can achieve this ?


Best answer by PaulKortman

@Scendre Andrew is correct that you cannot copy a single worksheet within Zapier alone. But you do have other more complicated/advanced options as I'll list below: (listed in order from easiest/less automated, to complicated/more automated)

  • You could have a stand alone workbook (Sheets Document) that you copy to create your new file. - You'd have one place to make the formatting update moving forward. (But it would not be in the same file as your other worksheets)
  • You could create a new sheet with headers from a Zapier step and then use a Google Sheets Macro to apply formatting to the headers/validation etc. Firing the macro from Zapier is not possible as far as I know.
  • You could create a new sheet with headers from a Zapier step and then use Google Apps Script to apply formatting to the headers/validation etc. - you can fire the Apps script via a webhook through the Zap.

Let us know if you're interested in any of these and we'll see if we can help you with one of those methods.


View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Hi @Scendre - you won't be able to copy a single worksheet, only the whole Google Sheet I'm afraid.


We're Zapier Certified Experts - we help businesses do cool stuff with automation | www.luhhu.com
PaulKortman
Forum|alt.badge.img+10
  • PaulKortmanZapier Expert
  • Zapier Expert
  • 469 replies
  • Answer
  • January 20, 2020

@Scendre Andrew is correct that you cannot copy a single worksheet within Zapier alone. But you do have other more complicated/advanced options as I'll list below: (listed in order from easiest/less automated, to complicated/more automated)

  • You could have a stand alone workbook (Sheets Document) that you copy to create your new file. - You'd have one place to make the formatting update moving forward. (But it would not be in the same file as your other worksheets)
  • You could create a new sheet with headers from a Zapier step and then use a Google Sheets Macro to apply formatting to the headers/validation etc. Firing the macro from Zapier is not possible as far as I know.
  • You could create a new sheet with headers from a Zapier step and then use Google Apps Script to apply formatting to the headers/validation etc. - you can fire the Apps script via a webhook through the Zap.

Let us know if you're interested in any of these and we'll see if we can help you with one of those methods.


Need Additional help? Feel free to reach out here: https://zapier.com/experts/connex-digital/
Scendre
  • Scendre
  • Author
  • 1 reply
  • January 22, 2020

Hmm thanks for your answers !

It seems that the better solution for me is the third one. If you have some ressources on how I can do that, I'll be happy to give it a try ! Thank you @PaulKortman :)


Terms & Conditions