Skip to main content
Best answer

Updating cells in monday.com using Google Sheets

  • February 24, 2022
  • 1 reply
  • 197 views

Hello, 

Hopefully you can help, I am trying update certain cells within a monday board when google sheets gets updated. We are trying to have a live spreadsheet which get updated everyday and we would like this to update monday board as well. I can get google sheets to add a row but I cant seem to find a way to update individual cells. Is there a way this can be done using a zap?

 

Many Thanks

Best answer by Troy Tessalone

Hi @MarcoPolo2022 

Best would be to store the Monday Item ID back on the GSheet in a new column for reference for updates into Monday.

 

Otherwise, to find a Monday Item, you can use this Zap action step:

 

Then, to update the Monday Item, you can use this Zap action step:

 

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
  • Answer
  • February 24, 2022

Hi @MarcoPolo2022 

Best would be to store the Monday Item ID back on the GSheet in a new column for reference for updates into Monday.

 

Otherwise, to find a Monday Item, you can use this Zap action step:

 

Then, to update the Monday Item, you can use this Zap action step: