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

Missing data in sample row from Google Sheets

  • 23 February 2021
  • 5 replies
  • 201 views
Z

I am looking into creating an integration: when there is a new data in Google Sheet like the one below, it will be added or updated on MailChimp.

However, when I am creating a trigger on the Google Sheet, I am confused why it says Spreadsheet Row A, Spreadsheet Row B, and Spreadsheet Row C. Isn’t it supposed to be Row Number? The first row of the Google Sheet is for the information column (First Name, Last Name, etc). Also, on the Google Sheet trigger no data is being displayed.

Trigger - Google Sheet

 

On the MailChimp action, I am getting a “Subscriber Email empty (required)” when I have data in the Google Sheet.

Action - MailChimp

 

icon

Best answer by Troy Tessalone 23 February 2021, 16:34

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.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Ziggy 

FYI: Having what appears to be a formula in column I will cause the Zap to not behave as expected.

Check out these help articles about GSheets: https://zapier.com/apps/google-sheets/help

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z

Hi Troy,

 

I removed the formula. It worked ok. However, I am getting this error:
 

 

The dates are already set to Month and Day

FYI, we cannot set the Amazon Order ID to month and date, since these are order numbers. In Mailchimp it is set as numbers.

 

 

Troy Tessalone
Userlevel 7
Badge +14

@Ziggy

It’s likely the Birthday field that needs to be in one of these formats.

Check your Merge field configuration on the Audience in the Settings of Mailchimp.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z

Birthday is set as MM/DD

Yet test still shows an error:

 

Troy Tessalone
Userlevel 7
Badge +14

Hi @Ziggy 

Check these fields:

Birthday

Purchase Date

In the GSheets screenshots both fields show as different formats with a dash, instead of with a slash as expected by Mailchimp.

For Birthday, 11-02 is different than 11/02

For Purchase Date, 08-18 would need to be 08/18/2021

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions