I’ve got a zap that Adds/Updates a subscriber once it’s been entered into a Sheet row. It mostly works but some critical cells seem to pull the data on the Data In, but not send on on the Data Out. The specific points are birthday and SMS phone number. Has anyone experienced this?
The SMS Phone Number is mapped to a cell with a number, and the birthday is linked to a cell with a date. Both the cells in Sheets have standard sheets format rules applied such as Date and a number format that adds spaces and there’s some light validation on the number cell to make sure there’s 11 digits and it adds a “0” to the beginning of the phone number.
Google Sheets to Mailchimp isn't send out the right data
Hi
For us to have more context, post screenshots of these:
- How your Zap steps are outlined and configured in EDIT mode
- How the top 3 rows of your GSheet are configured
- A specific example of the missing or malformed data points
NOTE: You can add Formatter step to handle numbers and dates
- Formatter > Numbers > Format Phone Number
- Formatter > Date & Time > Format
Thanks for the reply, here’s how the sheet looks in GSheets
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4c3ca5e8-d356-4f5e-980b-5aa820422a0c.png)
I’m only importing Columns A to I.
Here’s the data in:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/3a40e933-e2e0-41ca-8f48-f099cfd53b53.png)
And the Data Out:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/0fa24584-eb14-4be6-9cd9-88fb171fb3ac.png)
And the data is coming through when I set the Zap up:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/329500d6-0270-4f65-9ad6-d49e4193a119.png)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/7b131456-e1be-4ffd-afc1-a22eff19e75f.png)
Thanks for looking
Hi
Help article for how GSheets need to be formatted to work in Zaps:
https://help.zapier.com/hc/en-us/articles/8496276985101-Work-with-Google-Sheets-in-Zaps
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.