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!