Hey There,
We are using Stripe with Zapier to to pull in data and place to a google doc.
It seems though two weird things are happening, Our order dates come in incorrectly more than half the time
Example:
2022-10-11 17:35:14 -- Correct
44845.3087152778. -- Failed
Then our customer addresses will come in and be missing everything but the Zipcode.
Has anyone encountered this, if i pull in the stripe Data on one that failed running a test, it appears to work just fine.
Stripe Data missing
Hi
Good question.
For the date formatting issue, you can adjust that in GSheets.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/9c2f6ae9-7b96-4b09-a685-9e6243e9b837.png)
Hi
Good question.
For the date formatting issue, you can adjust that in GSheets.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/9c2f6ae9-7b96-4b09-a685-9e6243e9b837.png)
Thank you for that tip!
Hi
I’m glad you were able to get the issue with the dates fixed! I wanted to address your second questions as best as I could:
...
Then our customer addresses will come in and be missing everything but the Zipcode.
In my experience with Stripe, sometimes test data looks a bit different from live data. It could be that the customer address is coming in, but under different fields.
Could you check the “Data Out” on the Stripe trigger for one of these Zap runs where the address was mostly missing? That will show you all of the data that we got from Stripe.
You might be able to find where the address is in live data, if it exists. If you do find fields that contain the address in the “Data Out” tab, you can then map those specific fields in the Zap itself. That should work when the Zap runs live.
Can you check that and let me know what you find out? Thanks!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.