Connect Google Sheets and Stripe integrations
Effortlessly integrate Google Sheets and Stripe with Make for real-time updates and automated data management, eliminating tedious admin work and unlocking your workflow's full potential.
Receives data from the MAKE_FUNCTION or INTEGROMAT functions used in a sheet. Please note, the Sheets Add-On is required.
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Triggers when a new row is added.
Cancels a payment intent by its ID. For payment intents with status ’requires_capture’, the remaining capturable amount will automatically be refunded.
Cancels a previously created payout.
Captures an existing uncaptured payment intent by its ID.
Confirms a payment intent by its ID. Upon confirmation, the payment intent will attempt to initiate a payment.
Creates a new customer object.
Creates a new invoice by the customer ID.
Creates a new invoice item to be added to a draft invoice.
Creates a Payment Intent.
To send funds to your own bank account, you create a new payout object.
Creates a new refund.
Permanently deletes a customer. It cannot be undone.
Permanently deletes a draft invoice. Use "Void an Invoice" module for finalized invoice.
Permanently deletes an invoice item which is not attached to invoices, or if it’s attached to a draft invoice.
Finalizes a draft invoice by its ID.
Performs an arbitrary authorized API call.
Retrieves the balance transaction with the given ID.
Retrieves the details of an existing customer.
Retrieves the details of an existing invoice with the given ID.
Retrieves the details of an existing invoice item with the given ID.
Retrieves the details of a Payment Intent that has previously been created.
Retrieves the details of an existing payout.
Retrieves the details of an existing refund.
Retrieves the current account balance.
Updates the specified customer by setting the values of the parameters passed.
Updates the specified invoice by setting the values of the parameters passed.
Updates the specified invoice item by setting the values of the parameters passed.
Updates the specified payment intent by setting the values of the parameters passed.
Updates the specified payout by setting the values of the parameters passed.
Updates the specified refund by setting the values of the parameters passed.
Voids a finalized invoice with the given ID. This cannot be undone.
Returns a list of transactions that have contributed to the Stripe account balance.
Retrieves a list of customers.
Retrieves a list of invoice line items by the invoice ID.
Returns a list of existing payouts sent to third-party bank accounts or that Stripe has sent you.
Returns a list of all refunds you’ve previously created.
Retrieves a list of payment intents or filters by customer ID.
Retrieves all lines of the specified payment link.
Retrieves a list of customers filtered by criteria.
Retrieves a list of invoice items filtered by criteria.
Retrieves a list of invoices filtered by criteria.
Trusted by thousands of fast-scaling organizations around the globe
Automate your work. Build something new.
Just drag and drop apps to automate existing workflows or build new complex processes. Solve problems across all areas and teams.
Build your Google Sheets and Stripe integrations.
Unlock the full potential of your workflows with Make, the superior platform for integrating and automating applications. Imagine effortlessly using Stripe as a trigger to sync detailed spreadsheets with financial transactions in Google Sheets. With Make, real-time updates and streamlined data management are automated—eliminating manual entry and tedious admin work. Experience the future of productivity by integrating Stripe and Google Sheets.
Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
Appends a new row to the bottom of the table.
Adds a new sheet.
Appends multiple rows to the bottom of the table.
Updates multiple rows.
Cancels a payment intent by its ID. For payment intents with status ’requires_capture’, the remaining capturable amount will automatically be refunded.
Cancels a previously created payout.
Captures an existing uncaptured payment intent by its ID.
Clears a specified range of values from a spreadsheet.
Connect any app with Google Sheets and Stripe
Popular Google Sheets and Stripe workflows.
Discover the benefits of integrating Google Sheets and Stripe for automated financial tracking, timely reminders, and centralized data management. Simplify your workflow and enhance reporting effortlessly.
Save new Stripe charges automatically to a Google Sheets spreadsheet
Every time a new charge is created in Stripe, Make will automatically add that charge to a Google Sheet spreadsheet.
TRY IT ->Send reminders for unpaid Stripe invoices to your customers and escalate for multiple defaults 1/2
When you customers are past due on the invoices, store them on a Google Sheet for recording keeping and send the a reminder email. If they have more than one unpaid invoice on the sheet, escalate this to management for their attention.
TRY IT ->Save your daily Stripe balances to a database
Get your Stripe daily balances stored conveniently on a Google Spreadsheet and also sent as a notification to the relevant person/team on Slack.
TRY IT ->Save the total number of active customers in Stripe to a database
Keep up to date with the total number active customers in Stripe. This information will be stored on a Google Sheet and a notification will also be sent to the person/team on Slack. It is set up to execute on the first of each month.
TRY IT ->Delete all paid Stripe invoices from your database 2/2
In the first scenario the customers were added to a sheet when they have unpaid invoices. This scenario deletes them from the sheet once their invoices are paid in Stripe.
TRY IT ->Create BKP and FIK codes from new Google Sheets spreadsheet rows and send them to customers via Twilio
Every time you add a new row to your Google Sheets spreadsheet, Make will automatically send a registered sale data message using the EET module and update the spreadsheet with obtained BKP and FIK codes. Both codes will be then sent to your customer via Twilio. The template uses Sheet 2 in this [example spreadsheet](https://goo.gl/F4MLEq).
TRY IT ->Create a Taxpayer's Signature Code (PKP) from new Google Sheets rows and post it to Slack
Every time you add a new row to your Google Sheets spreadsheet, Make will automatically generate a Taxpayer's Signature Code (PKP) using the EET module and post it to Slack. The template uses this [example spreadsheet](https://goo.gl/qm1mgb).
TRY IT ->Generate ChatGPT Completions from Google Sheets Rows
Effortlessly enhance your content creation process by integrating ChatGPT with Google Sheets. This powerful template allows you to automatically generate relevant completions, ranging from SEO keywords to custom responses, boosting productivity and content quality with ease. [Learn more](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796?utm_source=make&utm_medium=in-app&utm_campaign=template)
TRY IT ->Add webhook data to a Google Sheet
Use this automation to instantly capture data from a webhook and automatically add it as a new row in a Google Sheet. This is ideal for real-time data logging, form submissions, or any event-driven updates that must be stored in a spreadsheet. [Learn more about webhooks!](https://www.make.com/en/help/tools/webhooks)
TRY IT ->
How to setup Google Sheets and Stripe in 5 easy steps
Log in to Make
Start by logging into your Make account to initiate the process of setting up your connections.
Connect Google Sheets
Add a Google Sheets module to your scenario and sign in with your Google account when prompted.
Complete Google Sheets Setup
Once signed in, verify that the Google Sheets connection is successful.
Connect Stripe
Add a Stripe module to your scenario and choose your preferred connection method.
Complete Stripe Setup
Authenticate your Stripe account and save the connection settings to finalize linking the two applications.
Key Benefits of Integrating Google Sheets and Stripe for Automation
Integrate Google Sheets with Stripe to automate financial tracking, invoice reminders, balance updates, customer monitoring, and data centralization for real-time analytics.
Automatically save new Stripe charges to Google Sheets for real-time financial tracking and analysis.
Send automatic reminders to customers for unpaid invoices and escalate to management if necessary.
Store daily Stripe balances in Google Sheets and notify relevant teams on Slack.
Keep an up-to-date record of active Stripe customers and notify teams monthly.
FAQ
How it works
Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.
Trusted by 500,000+ Makers
"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."
"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."
"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."
"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."