Skip to main content
Question

How do I create a Google Sheet if it doesn't exist and update it if it does, with a dynamic sheet name?

  • August 1, 2023
  • 1 reply
  • 507 views

I want to do one thing. Create a Google sheet if that sheet does not exist, and update the sheet if it does.

The sheet’s name is dynamic based on the incoming data. So if a sheet with the title [incoming data title] exists, create a new row in that sheet. If sheet with the title [incoming data title] does not exist, create that sheet.

I have tried with all the available Google sheet actions and custom paths, and am at a loss. How do I do this?

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 1, 2023

Hi @hoobe 

Good question.

Check out this topic: