Skip to main content
Question

How do I get the date of payment from Stripe in a Google Sheets?

  • May 21, 2025
  • 5 replies
  • 44 views

We are pulling completed payments from Stripe to a G sheet. I have all pertinent info coming in great, but I would really to have the date of payment come in as well. I do not see an option for this and it does say if we use the time zone option it would come through, but it is not, any ideas?

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • May 21, 2025

Hi ​@JHartanov 

To narrow down the variables to map, try searching for this value: 2025

You can always use a system generated timestamp for when the Zap step runs: https://help.zapier.com/hc/en-us/articles/8496275717261-Insert-the-time-your-Zap-runs-into-a-field

 

 


  • Author
  • Beginner
  • May 21, 2025

Hi Troy, thank you!  How exactly do I do this? I don’t see where I can add another step or anything like you are suggesting. Appreciate your help!


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • May 22, 2025

Hi ​@JHartanov,

 

Welcome to the Community.

To include the payment date from Stripe in your Google Sheet, check the available Stripe data fields in your Zap, searching for labels like "Created" or "Payment Date." If a direct field isn't available, use the system-generated timestamp as an alternative by mapping "Zap Meta Human Now" or "Zap Meta Timestamp." You can also add a "Formatter by Zapier" step to modify date formats. Finally, test your Zap to ensure accurate data recording in your sheet.

If you continue to have trouble finding the payment date, please provide more details about the data fields available from Stripe, and I'll be happy to assist further. Thank you for reaching out, and I hope this helps!


  • Author
  • Beginner
  • May 22, 2025

Hi JammerS, thanks for this. I will try in a bit and let you know what I have come up with!


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • May 23, 2025

Hi ​@JHartanov,

 

Sure thing, just keep us on the loop so we can assist you further if needed. Thank you.