Best answer

Mirror Monday.com column updates to Airtable

  • 10 September 2020
  • 3 replies
  • 258 views

Userlevel 1

I need an easier way to push information from Monday.com to Airtable.  Currently it can be done but setting it up is a bit labor intensive.  My current method is as follows:

  1. Column change in Monday sends a webhook to Zapier
  2. Zapier initiates a path by Zapier action
  3. There is a path setup for each Monday column
    • e.g.  Path A:   Event Column ID | Exactly matches | text9
  4. The path maps to the appropriate Airtable column

This only appears to be necessary for text columns as they all send data in the event_value_value variable (other column types use other variable names e.g. event_value_address I can use to map to the Airtable columns).  The path method works fine, it’s just a fair amount of work to set it up.

 

I am presuming the paths by zapier if the equivalent of an ‘if’ statement.  What I’m wondering is can I use ‘code by zapier’ or some other method to more quickly deploy this for new Monday board?

icon

Best answer by Rhythm-Interior 13 September 2020, 12:31

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 +11

Hi @Rhythm-Interior!

I’m not sure if it would be appropriate for your use case but would one of these options work for you instead of using a Webhook:

Then rather than use Paths you could look into a Lookup Table (part of our Formatter app). See if that helps you out at all :)

Userlevel 1

Hi,

 

Thanks heaps the response, very much appreciated!  This isn’t quite what I’m after in this particular case, but I do have other situations for which this will be very useful!  In any case I did manage to figure this out in the end, I’m now using webhooks to trigger a POST request that grabs everything I need to pass to the next step.

 

Cheers,
Matt

Userlevel 7
Badge +8

@Rhythm-Interior thanks for sharing how you solved this one!