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 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.

Best answer

Google Sheets: "Error: required field is missing"

  • 28 November 2022
  • 6 replies
  • 466 views
Community Dani
Userlevel 1

Dear Community,

I am trying to implement the following Zap:

“Add custom role to user in inSided when new or updated spreadsheet row (team drive) in Google Sheets”

 

I basically want to bulk-assign one role to 200+ users.

Use case: I have a list of 200+ participants of an online event, and I want to assign them an inSided custom role in order to “tag” them with a specific custom role (e.g. AMA attendees) so I can view some user analytics for this group and see if their community usage has increased. 
(May be interesting for our Zapier Community Managers too, since we use the same tool ) 😇

 

So here is an example of the spreadsheet

 

Column A has the email, column B a user ID (as a formula, gathered via VLOOKUP) and column D the user ID ( no formula but rather text only, basically it’s a Shift+Cmd+V of column B.)

 

Here is my setup

 

Now I wanted to test it

 

But I am getting the following error

 


Any idea what the error could be? Am I missing something?

This is my very first Zap.

 

 

thanks so much in advance for your help!

 

Best,
Daniele

icon

Best answer by MohSwellam 28 November 2022, 17:54

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.

6 replies

MohSwellam
Userlevel 7
Badge +8

Hi @Community Dani 

 

From what I can see in the Zap Editor, the value for Col D is Blank and its a required field. This just means that the test row from the trigger doesn't have a value in Col D. Its probably the very last row in Google Sheets (probably an empty row). 

 

What you would do is delete all the rows that are currently empty in the Google Sheet then reload new test data in the Trigger. This should work. 

 

Alternatively, I would actually use Airtable for something like that. 

Founder of GeekyAir.com
Community Dani
Userlevel 1

Hi @MohSwellam thank you so much for your quick reply!

I deleted all of the blank rows, but I get the same error.

Any idea what it could be now?


Side-question: the condition is “when new or updated spreadsheet row (team drive) in Google Sheets”

Do I need to update a row while I do the testing for this to work? Because as of now, the sheet already contains all the date.

 

Alternatively, I would actually use Airtable for something like that. 

Unfortunately we don’t have an Airtable account, so I would like to keep this on Zapier.

Community Dani
Userlevel 1

FYI it still says no data even though literally every row in COL D contains data.

 

Troy Tessalone
Userlevel 7
Badge +14

@Community Dani 

Check the Row/ID that is returned in the Zap trigger step to help you troubleshoot which Row’s data is being used.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
MohSwellam
Userlevel 7
Badge +8

Hi @Community Dani 

 

Just to be clear, I was suggesting Airtable as an alternative to Google Sheets, not to Zapier 😁

 

After deleting the empty rows, did you go back to the Trigger and Load More test data? 

 

And yes, it is a good idea to add a new row (maybe copy an existing row) then click on Load More. 

 

Founder of GeekyAir.com
Community Dani
Userlevel 1

Thank you @Troy Tessalone I’ll keep that in mind!
 

Yeeehaw!!
 

@MohSwellam thank you for adding that last screenshot - I only now realized that, after making the changes, I had to go back to 1. (Trigger) and edit the settings in there too! (not just the “Action” step)
rookie mistake ;)

Thank you for your help! You guys are the best!

Terms & Conditions