Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

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!

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

 

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

@Inika 

There are 2 variables you can use:

  • Row
  • ID

Thanks. that worked!

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! 😊

Terms & Conditions