Are you looking for an easy method to add new Stripe refunds automatically to Google Sheets as rows? Well in this article, we will definitely show you a solution to this problem.
In this blog, we will explain to you the entire process to integrate Stripe with Google Sheets to automate your work via Pabbly Connect. But first, let’s know a little bit about these two services that we are going to integrate. 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 allows users to edit, organize, and analyze different types of information. It allows collaborations, and multiple users can edit and format files in real-time.
On connecting Stripe with Google Sheets, whenever there will be any refunds in your Stripe account, the info will be automatically updated in your Google Sheets. To help you with this we are recommending the best automation and integration 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 and integration tools that allow you to integrate unlimited apps without any coding skills. Moreover, you can also access its features such as filters, path routers, etc even in its free plan.
Therefore, without taking any more of your time, let’s get into the blog about how to add new Stripe refunds automatically to Google Sheets as rows.
Step 1: Sign up to Pabbly Connect
Start the process to add new Stripe refunds automatically to Google Sheets as rows by visiting the website of Pabbly Connect and then click on the “Sign-Up Free” button. On the registration page, either signup using an existing Gmail account or manually fill out the form.
Try Pabbly Connect for FREE
Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect. Start with creating a workflow for your project by clicking on the “Create Workflow” button. Now, you need to name the workflow just like in the above-shown image. I named the workflow as “Stripe to Google Sheets”, you can obviously name the workflow as per your requirements and needs. After naming your workflow, you have to select the application you want to integrate. Pabbly Connect allows you to integrate unlimited premium applications, create your free account now. Now, you have to select the application that you want to integrate. In this case, we are choosing “Stripe” for integration. After selecting the application select “New Refund” in the choose method section. After selecting the application, now you have to copy the webhook URL just like in the above-shown image to take further the integration process. To connect Stripe with Pabbly Connect, you have to paste the copied webhook URL in your Stripe account, for that, you need to log in to your Stripe account. Once you log into your Stripe account, go to the “Developer” section on the left of the dashboard. After that, click on the “Webhooks” option. Once you click on the webhook link, your stripe account’s webhook page will appear, here you have to click on the “Add Endpoint” button. Next, paste the webhook URL and select “Charge Refunded” from the event to send section, and then hit the “Add Endpoint” button. Now to make a refund, click on the “Payments” option in your Stripe dashboard. Next, you have to select any one of the payments and then click on the “Cancel Payment” option. Here, you have to select the reason for the refund, we chose the reason as “Fraudulent” you can choose whatever you want. After making all the required changes hit the “Refund and Block” button. But before that, click on the “Capture Webhook Response” button in the Pabbly Connect dashboard. As soon as you click on the “Refund and Block” in Stripe and “Capture Webhook Response” in Pabbly Connect the entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option. Now as you see in Test response, it is not capturing email address, name, etc so the next step is to retrieve Stripe customers details such as name, email, address through customers id. Now in this step, click on the + button below and choose the application that you want to integrate. Here we will choose “Stripe” to integrate and in the method section select “Retrieve a Customer”. After choosing the application click on the “Connect with Stripe” button to move forward. After you click on the connect button, a pop-up will slide in asking for an API key. To get that API key, click on the “Developers” section in your Stripe dashboard and then click on the “API Keys”. In the API Keys section, you can find a secret key, simply copy the key to move further. Next, paste the copied API key in the Pabbly Connect dashboard and then hit the “Save” button. After connecting with Stripe via API key, now map the customer ID we got in the trigger section and then hit the “Save & Send Test Request” button. Here we can see that we retrieved the customer info like name, address, email, etc via customer ID. Now click the “Save” button to take the integration process further. Now as you know the amount is not in the proper decimal system so we are setting an action to trim the amount. Now in this step, we will be selecting the “API” as action and in the action event we will select “GET”. We are using this action to trim the amount into a proper decimal system. So, to trim the amount, paste “https://forms.pabbly.com/api/trim_amount” in the endpoint URL section, and in the parameters section fill the amount and select the amount from the dropdown. After filling in all the details, click on the “Save & Send Test Request” button. Here via API action, we have retrieved the amount into the proper decimal system. Now hit the “Save” button to save the API response. To make this Stripe-Google Sheets integration work, you have to choose the action for your trigger. Now in this step, click on the + button below and choose the application that you want to integrate. Here we will choose “Google Sheets” to integrate and in the method section select “Add New Row”. After choosing the application click on the “Connect with Google Sheets” button to move forward. When you click on the “Connect” button, a window will slide in from the right, here you have to again click on the “Connect with Google Sheets” button and then choose the account through which you want to log into your Google account to connect Google Sheets. After connecting with your Google account, map all the fields quickly like email, name, etc. Once you are done adding up all field data click on the “Save & Send Test Request” button. Here, you can see that our integration was successful and the Stripe refund info has been updated in Google Sheets automatically. Now, whenever there will be any new refund in your Stripe account, the info will be automatically saved in your Google Sheets. Now, you know how to add new Stripe refunds automatically to Google Sheets as rows. This is a one-time process, after this every time there will be any new refunds in your Stripe account the info will be automatically updated in your Google Sheets. All you have to do is follow all the above-mentioned steps and you’re good to go. Using Pabbly Connect, you can integrate limitless applications & create unlimited workflows. So let’s start your automation and integration work with a free account on Pabbly Connect. Moreover, if you have any queries, you can always contact us.Step 2: Access Pabbly Connect
Step 3 : Workflow for Stripe with Google Sheets Integrations
(a) Create New Workflow
(b) Name the Workflow
Step 4 : Setting Triggers for Stripe with Google Sheets Integrations
(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 Payments
(e) Click on Cancel Payment
(f) Make the Refund
Step 6 : Test the Submission in Pabbly Connect Dashboard
Step 7 : Retrieve Stripe Customer Details
(a) Select Application you want to Integrate
(b) Click the Connect Button
(c) Click on the API Keys
(d) Copy the API Key
(e) Paste the API Key
(f) Retrieve the Customer
(g) Save the API Response
Step 8 : Setting Action to Trim Amount
(a) Select Application you want to Integrate
(b) Save the API Response
Step 9: Setting Action for Stripe with Google Sheets Integration
(a) Select Application you Want to Integrate
(b) Click the Connect Button
(c) Authorize Application
(d) Map the Fields
(e) Save and Send Test Request
Step 10: Check Response in Google Sheets
Conclusion –
You May Also Like to Read –
