Using Zapier to update a google sheet from Monday boards

Platform discussions
, ,
1

Hi Everyone,

I’m currently trying to Take data from a Monday board with multiple columns and values and have when a row is updated from Monday then go and update the google sheet which I know works.

When I go into Zapier I have to do each row line by line, is there a way that’s universal to tell the option in Zapier to not choose 1 row but all rows ? and if any of the columns get updated from Monday board to update inside of the Google Sheet?

I hope I’ve made that make sense

From the image attached, Lets say I want to change a status from Milestone and the status changes from City and Utility I want it to reflect in the Google Spreadsheet (This I confirmed worked!)

However we have probably over 100+ line items and I want to create a Zap that would accommodate all of the rows without having to go by each row in a zap in Zapier and make multiple zaps.

Is this possible does someone understand what I’m trying to do?

Thanks,

board
board2383×183 72.7 KB

2

hi @jamesb33

Not sure I fully understand the use case. There is no bulk update available in the API, it’s all item by item. If you want to change multiple items you should be able to multi-select those items and make the change. This will call you ZAP for each item that is changed. Does that make sense?

3

I basderbruin, Yes I believe I undrestand the issue.

So in order to have each row and column updated I need to create a Zap for each row ? is that my understanding

Thank you

4

hi @jamesb33

You only need one ZAP that get called on a change on every column

5

One ZAP based on a change from monday any column will generate a change in a google sheet is that right?

6

mmmm… don’t know your exact use case. In general: when you have a service (Zap, Make, own developed) that listens to events from monday, each column change will generate that event. The event data structure contains the boardId, itemId etc. and with that your app can update monday through the API (or ZAP modules).

7

update multiple rows in Google Sheets based on changes from a Monday board, you can use the “Update Spreadsheet Row(s)” action in Zapier. Here’s a step-by-step guide:

  1. Set up a trigger in Zapier using the Monday app to detect changes in your board.
  2. Add a “Filter” step to specify the conditions for the rows you want to update in Google Sheets.
  3. Follow the Filter step with the “Update Spreadsheet Row(s)” action.
  4. In the “Update Spreadsheet Row(s)” action, select the Google Sheets app and the specific sheet you want to update.
  5. Map the fields from your Monday board to the corresponding columns in Google Sheets.
  6. Ensure the action is set to update all matching rows.

This way, when a status changes in the Monday board, Zapier will identify the matching rows in Google Sheets and update them accordingly. This approach allows you to handle multiple rows in a single Zap without creating separate ones for each row.
For More Detail Book a free Call with Zapier Expert.

8

(post deleted by author)