Best answer

Setting up a daily zap (sheets-coda)

  • 24 March 2020
  • 3 replies
  • 53 views

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 !

icon

Best answer by Danvers 1 April 2020, 17:09

View original

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

Userlevel 7
Badge +8

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!

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
Userlevel 7
Badge +12

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!