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
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.
So, let’s start the integration process.
Step 1: Sign up to Pabbly Connect
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
Later on, after logging into the account, simply tap on the “Access Now” button as shown in the above image. Now, let’s begin the procedure of building a workflow for integration by pressing on the “Create New Workflow” button. 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. 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. 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. 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. 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. 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. 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. 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. Subsequently, now go back to the “Payment” section on the left of the dashboard, after that just press the “New” button to add payment. 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. Once you tap on the “Add Payment” option, the entry will appear on the “Pabbly Connect” dashboard. Just tap on the “Save” option. Consequently, in order to make this Stripe and Google Sheets integration work, you have to choose the action for your trigger. 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. After pressing the “Connected with Google Sheet” button, an authorization window will open up, so that you can log in to your Google account. 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”. 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. Finally, as you can see, all the entered details have been auto-populated in the Google Sheets. 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.Step 2: Access Pabbly Connect
Step 3: Workflow for Stripe & Google Sheet Integration
(a) Start with a New Workflow
(b) Name the Workflow
Step 4: Setting Trigger for Stripe & Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Copy the Webhook URL
Step 5: Connecting Stripe to Pabbly Connect
(a) Go to Developer Section
(b) Click on Add Endpoint
(c) Paste the Webhook URL
(d) Click on Payment Option
(e) Add Payment
Step 6: Test the Response in Pabbly Connect Dashboard
Step 7: Setting Action for Stripe & Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Click the Connect Button
(c) Map Field Data
(d) Test the Submission and Save
Step 8: Check Response in Google Sheet
Conclusion –
You May Also Like To Read –
