Skip to main content
Best answer

How to update Google Sheets with Stripe subscription status using a scheduled transfer?

  • Jul 13, 2023 4:16 PM UTC
  • 5 replies
  • 118 views

I have a zap connecting Stripe and Google Sheets. A new row is added to Sheets every time a new subscription is created. I want the google sheet to be updated once everyday with the Status of the subscription so it captures cancellations. Status is a seperate column in the sheet. 

I thought of setting up a scheduled transfer between Stripe and Google Sheets. It would need to lookup the subscription id (Column 1) in google sheets in the Stripe subscription database and then update the status. Am not sure how to accomplish this. Any help is appreciated!

Best answer by Troy Tessalone

@Inika 

There are 2 variables you can use:

  • Row
  • ID
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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Jul 13, 2023 4:47 PM UTC

Hi @Inika 

Good question.

Make sure to log the Subscription ID as a column in the GSheet.

Try these Zap steps:

  1. Trigger: Stripe - Canceled Subscription
  2. Action: GSheets - Lookup Row
  3. Action: GSheets - Update Row
    1. Map the Row ID from Step 2

 


  • Author
  • Beginner
  • Jul 13, 2023 4:54 PM UTC

Thankyou. I don’t see the option of “Row Id from Step 2” listed in the dropfown in step 3. 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • Jul 13, 2023 4:57 PM UTC

@Inika 

There are 2 variables you can use:

  • Row
  • ID

  • Author
  • Beginner
  • Jul 13, 2023 6:29 PM UTC

Thanks. that worked!


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Jul 17, 2023 6:59 AM UTC

Hi @Inika,

Thats fantastic news! I’m glad Troy was able to help you out!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 😊