Are you looking for a way to save new Stripe charges automatically to Google Sheets? If yes, here in this article we will provide a step by step guide to integrate Stripe with Google Sheets.

But before moving forward, let’s know a little bit about both the software & why there is a need to integrate Stripe with Google Sheets. As we all know, Stripe is a payment infrastructure that allows you to accept payments and manage payouts for all kinds of businesses. On the other hand, Google Sheets Online is spreadsheet software that allows users to create, update & modify spreadsheets and share the data live online, and much more.

By connecting Stripe with Google Sheets, one can automatically save every Stripe charge to Google Sheets in real-time. To help you with this we are recommending business automation software named Pabbly Connect.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect         

Pabbly Connect is one of the best automation tool that allows you to integrate unlimited apps without any coding skill. Moreover, you can also access its features such as filters, path routers, etc even in its free plan.

Here in this article, we will understand how to integrate Stripe and Google Sheets using an automation tool i.e Pabbly Connect.

How to Save New Stripe Charges Automatically to Google Sheets (step by step)

So, let’s start the integration process.

Step 1: Sign up to Pabbly Connect

Sign Up

The process of connecting Stripe to Google Sheets starts by pressing the “Sign Up Free” button on the Pabbly Connect dashboard. Furthermore, you can either manually enter the entire details or else sign up via Gmail credentials.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Later on, after logging into the account, simply tap on the “Access Now” button as shown in the above image.

Step 3: Workflow for Stripe & Google Sheet Integration

(a) Start with a New Workflow

Create New Workflow

Now, let’s begin the procedure of building a workflow for integration by pressing on the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Additionally, now name the workflow that in our case is “Stripe to Google Sheets”. However, you can always change the workflow name according to your requirements.

Step 4: Setting Trigger for Stripe & Google Sheets Integration

After building a workflow, now choose the integration app to connect your Stripe account to Google Sheets. Pabbly Connect lets you create unlimited workflows within minutes, tap here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate

Now, it’s time to choose the application i.e, “Stripe” from the dropdown, then choose the method i.e, “New Charge” to add payments in Google Sheets automatically.

(b) Copy the Webhook URL

Copy the Webhook URL

Later on, you have to copy the webhook URL that is appearing on the dashboard. You can either copy the link directly or else click on the “Copy” button.

Step 5: Connecting Stripe to Pabbly Connect

However, in order to save new Stripe charges automatically to Google Sheets, you gotta paste the copied Webhook URL in the software. Hence to do that, you have to log in to your Stripe account.

(a) Go to Developer Section

Go to Developer Section

Once you log into the Stripe account, just go to the “Developer” section on the left of the dashboard. Then, press on the “Webhooks” option.

(b) Click on Add Endpoint

Click on Add Endpoint

Afterward, when you click on “Webhooks”, an endpoint tab will open up, just tap on the “Add Endpoint” option in order to paste the Webhook URL.

(c) Paste the Webhook URL

Paste the Webhook URL

Once you press the “Add Endpoint” button, it will open up the window with options. All you need to do is paste the copied URL in the “Endpoint URL” section. Moreover, you have to make sure that you select charge.succeeded in the “Event to Send” column. Ultimately, just tap on “Add Endpoint” to save the setting.

(d) Click on Payment Option

Click on Payment Option

Subsequently, now go back to the “Payment” section on the left of the dashboard, after that just press the “New” button to add payment.

(e) Add Payment

Add Payment to Save New Stripe Charges Automatically to Google Sheets

As soon as you click on the “New” button, a pop-up will appear. Simply enter all the required details & press the “Create Payment” button at the bottom. But before you that, you have to click capture webhook response in the Pabbly Connect dashboard.

Step 6: Test the Response in Pabbly Connect Dashboard

Test the Response

Once you tap on the “Add Payment” option, the entry will appear on the “Pabbly Connect” dashboard. Just tap on the “Save” option.

Step 7: Setting Action for Stripe & Google Sheets Integration

Consequently, in order to make this Stripe and Google Sheets integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Application you Want to Save New Stripe Charges Automatically to Google Sheets

Next, hit the “+” icon and then select “Google Sheet” application & in the choose method option, select ” Add New Row”. Afterward, just click on the button named “Connect” in order to authorize it with Google account.

(b) Click the Connect Button

Click the Connect Button to Save New Stripe Charges Automatically to Google Sheets

After pressing the “Connected with Google Sheet” button, an authorization window will open up, so that you can log in to your Google account.

(c) Map Field Data

Map Field Data to Save New Stripe Charges Automatically to Google Sheets

All the sheets in your account will appear on the dropdown, just select the sheet that is “Sheet1”. After that, add the necessary field from drop-down like for the name, amount, and seller message. Following that, simply tap on the button named “Save & Send Test Request”.

(d) Test the Submission and Save

Test the Submission and Save to Save New Stripe Charges Automatically to Google Sheets

Consequently, once you hit the “Send Test Request”, all the entries will be sent to Google Sheets Rows. Just hit the “Save” button in order to save the entire workflow.

Step 8: Check Response in Google Sheet

Check Response in Google Sheets to Save New Stripe Charges Automatically to Google Sheets

Finally, as you can see, all the entered details have been auto-populated in the Google Sheets.

Conclusion –

Hopefully, Now you know how to save new Stripe charges automatically to Google Sheets. Moreover, it’s a one-time process, so you don’t have to worry about doing it again and again. So, just sit back and relax!! As by using Pabbly Connect one can easily avoid repetitive work that allows unlimited premium applications.

So, wait no longer. Go and get your access by signing up for a free account.

You May Also Like To Read –