About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How to automatically create a new Item ID using the "Change Multiple Columns Value in monday.com" integrated with Google Forms?
Question

How to automatically create a new Item ID using the "Change Multiple Columns Value in monday.com" integrated with Google Forms?

  • 17 March 2023
  • 3 replies
  • 349 views
vic_rad

I integrated Google Forms with Monday.com to immediate reflect data on the dashboard. The Google Forms results will be a recurring process thus multiple items will be reflected in the Monday.com board. 

 

I used the trigger: 1. Change multiple columns value in monday.com when new or updated form response in Google Forms then action will be: 2. Change Multiple Columns Value in monday.com
 

My problem is, Zapier is requiring for an Item ID. New responses from Google Forms will over ride the column values since it is by default referenced to item 1. I cannot always update the Monday.com dashboard just to ensure new Google Form results will not override the row referenced to item 1.

 

Is there a way for Zapier to automatically change this Item ID so that the results will be more accurate? Thanks!

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

nicksimard
Userlevel 7
Badge +11

Hi@vic_rad!

I’m not 100% sure I’m following what the workflow is.

Since you need the Item ID in your action step, you have a few options:

  • always select the same Item ID, by picking one from the dropdown in your Zap (unlikely to be what you want)
  • get the Item ID from the trigger step itself (also pretty unlikely)
  • have a lookup table that you can reference, using data from the Google Forms trigger (this can use Google Sheets, Airtable, Formatter’s Lookup Table, etc)

A few useful posts about lookup tables:

Does that help at all, or have I misunderstood what you’re asking for? If so, can you elaborate on what problem you’re trying to solve? Thanks!

vic_rad

Thank you for your reply @nicksimard 

 

Here’s a more detailed scenario relating to my problem:

  • Every day, orders are coming in via google forms. I want it to be reflected immediately in our monday.com dashboard which is why I tried to use zapier with the trigger: Change multiple columns value in monday.com when new or updated form response in google forms then will have an action: Change Multiple Columns Value in monday.com
  • This trigger and action combination requires a default item ID from the side of monday.com
  • Now this is where my problem comes in… I cannot always check and change the connected default item ID in my zap just to match the item ID with monday.com as I cannot anticipate when orders will be coming in
    • Order #1 will use item ID 1 therefore cannot use the same item ID anymore
  • I also tried changing the default item ID in my zap however, it does not add a new layer of rows as an additional input instead it just overwrites the previously generated multiple columns from the google form - it does not populate my monday.com board with new rows of information from the new google form results using this zap trigger and action combination

Is there a better way to achieve my objective? Or am I missing something with my combination of trigger and action choices? 

 

I’m not sure if the lookup table will work but will take a look as well. 

Brem
Userlevel 4
Badge +6

Hi @vic_rad 

I looked for options, and I suggest you try using the Get Column Values step, then put it between the trigger and the Change Multiple Columns Value action step on monday.com.

But please let us know how it goes after you try the Lookup Table step!

Terms & Conditions