Question

How can I create a Google Sheet by copying an existing sheet and linking it to monday.com?

  • 30 May 2023
  • 1 reply
  • 16 views

Userlevel 1

I would like to when a status changes in monday.com, that a google sheet is created via copying an existing one and create a link to the google sheet from monday.com but I cannot see a way of getting the link to the google sheet that would be created via the zap.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +12

Hi @Patrick Hall, welcome to the community!

You can use the Create Spreadsheet Google Sheets action to create the sheet (copying an existing sheet). When you use that action, in addition to creating the sheet, the Zap will give you a link to the sheet, which you can use in the following step(s) of your Zap. 

The output of a “Create Spreadsheet” Google Sheets action. It provides, sheet ID, worksheet ID and the Sheet url

 

​I hope that helps, please let us know if you have any questions!