My goal: Zap data from Monday.com to a Google Sheet when a new entry is added to a specific board on Monday.
My problem: Although I have identical columns in Google Sheet as I do on the Monday board (and data seems to be flowing between them), the columnular data from Monday seems to be arriving as a key:value pair (almost like JSON). Is there any way to extract this into separate fields for the Sheet? In the screenshot (which I've tried to remove any identifiable info from), you can see that the Name field maps well, but as soon as we get to the next Sheet field ("Google Ads ID"), I basically get all of the rest of the data as one field called "Column Values". Is this just an issue with Monday.com's API or is there something I can do to further extract that data?
Thanks in advance!
Best answer by AndrewJDavison_LuhhuView original
I had to find out the hard way that you need to create a webhook step to call the Monday.com API to get data from an individual column:
The Intuitive Management Tool - Developers
It will end up looking like this:
(remember to get your API key from Monday.com settings).
Also, you need to use the collumn's internal ID, not it's name in Monday.com. If you need help finding that, open this link in your browser:
(replace [boardidhere] and [apikeyhere] accordingly)
You'll see this:
In this example, the column in Monday called "Reference Number" has a column ID of "text13"
Hope that helps!
My particular zap triggered on a new updated added to a pulse (suited my usecase), but "New Pulse On Board" should also do fine.
It will give you the board ID and pulse ID you need for the webhook call.
Annoying, right?! I hope Monday.com improve their integration.
This thread has been really useful. We are an event space that takes bookings from event organisers. We use Monday.com as our CRM to log enquires and would like to automate these into a Google Sheet for the purposes of sharing with our wider team.
We are attempting to automate a Monday.com board into Google Sheets. We are however stuck at a point where anything we pull through into the Google Sheet comes out with the name of the column in each cell.
We have followed the advice in this thread but are stuck at this point. Our customised GET looks as such.
Can anybody advise where we may be going wrong??
The Hinterlands team
@Hinterlands and hello again @AndrewJDavison_Luhhu!
It sounds like you may be populating the Sheet with the key rather than the value? As Andrew says, we'd need to see some sample data from that GET to confirm.
@AndrewJDavison_Luhhu & @redearmedia,
Will do our best to provide examples - sorry we're very new to this sort of stuff.
Hope the below provides what you need to be able to help :)
The values are coming back as saying there is nothing there (null) when we update the date column on Monday.com, which is titled column id. date4.
Thanks for your help - think we're a little out of our depth 😋
So, it's definitely the value field you should be mapping... but as to why it's showing null for you isn't clear.
It may be worth reaching out to the Monday.com team for help - we had a few problems with their API and they were super helpful. They should be able to tell you why it's returning null.
EDIT: updated section 2
One thing I did find is when I used GET to retrieve a formula column on my Monday.com board - that also came through null. It seems it can't pull back values for dynamic fields.
I'm wondering if this date field is the same?
New to Monday.com and surprised this zapier integration is so botched. The column values data is not even valid json, it’s a mess of random stuff jumbled together as far as I can see. Surprised Zapier would allow this to be live. Hopefully Monday team fixes soon.