Skip to main content
Best answer

Setting up a daily zap (sheets-coda)


Hello, 

 

I need to setup a zap which will daily simply copy a table from Sheets to Coda. Upsert will not work as I need t obe able to delete records that are no longer present in the source sheet from the destination Coda table. 
My second use case is the oposite - I need to daily copy an entire table from coda to a sheets tab and completly replace the data in that sheet. 

Thanks for all te help in advance !

Best answer by DanversBest answer by Danvers

Hi @val_t I’m sorry for getting back to you in the Community, though I can see that you also sent a message to our Support Team and have had a response from them. 

 

It looks like we’re not going to be able to help with this workflow because it’s not possible to delete rows in Coda, I’m sorry that we can’t help with this one!

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

steph.n
Forum|alt.badge.img+8
  • Builder
  • 899 replies
  • March 25, 2020

Hi @val_t - Thanks for writing in! 

We were curious how big this table is in Sheets that you’re trying to copy into Coda? And vice versa?
 

Thanks so much!


  • Author
  • Beginner
  • 1 reply
  • March 25, 2020

Hey 

Thanks for your reply 

 

  • Sheets → Coda - there are roughly 500 usually rows and no more than 1000
  • Coda → Sheets - I have 2 use cases
    • 100 rows
    • 5000 rows

Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • Answer
  • April 1, 2020

Hi @val_t I’m sorry for getting back to you in the Community, though I can see that you also sent a message to our Support Team and have had a response from them. 

 

It looks like we’re not going to be able to help with this workflow because it’s not possible to delete rows in Coda, I’m sorry that we can’t help with this one!