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

Sign Up To Pabbly Connect 

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

Sign Up

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

Step 2: Access Pabbly Connect

Select Connect

Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect.

Step 3 : Workflow for Stripe with Google Sheets Integrations

(a) Create New Workflow

Create New Workflow

Start with creating a workflow for your project by clicking on the “Create Workflow” button.

(b) Name the Workflow

Name the Workflow

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.

Step 4 : Setting Triggers for Stripe with Google Sheets Integrations

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.

(a) Select Application you want to Integrate

Select Stripe

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.

(b) Copy the Webhook URL

Copy the Webhook URL

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.

Step 5 : Connecting Stripe to Pabbly Connect

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.

(a) Go to Developer Section

Click on Developers

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.

(b) Click on Add Endpoint

Click-on-Add-Endpoint-1

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.

(c) Paste the Webhook URL

Paste the Webhook URL

Next, paste the webhook URL and select “Charge Refunded” from the event to send section, and then hit the “Add Endpoint” button.

(d) Click on Payments

Click on Payments

Now to make a refund, click on the “Payments”  option in your Stripe dashboard.

(e) Click on Cancel Payment

Clcik on Cancel Payment

Next, you have to select any one of the payments and then click on the “Cancel Payment” option.

(f) Make the Refund

Click on Refund & Block

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.

Step 6 : Test the Submission in Pabbly Connect Dashboard

Save the Webhook Response

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.

Step 7 : Retrieve Stripe Customer Details

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.

(a) Select Application you want to Integrate

Select Stripe Action

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”.

(b) Click the Connect Button

Click Connect Stripe

After choosing the application click on the “Connect with Stripe” button to move forward.

(c) Click on the API Keys

Click on API Key

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”.

(d) Copy the API Key

Copy the API Key

In the API Keys section, you can find a secret key, simply copy the key to move further.

(e) Paste the API Key

Paste the API Key

Next, paste the copied API key in the Pabbly Connect dashboard and then hit the “Save” button.

(f) Retrieve the Customer

Map the Customer ID

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.

(g) Save the API Response

Save the API Response

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.

Step 8 : Setting Action to Trim Amount

Now as you know the amount is not in the proper decimal system so we are setting an action to trim the amount.

(a) Select Application you want to Integrate

Select API Action

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.

(b) Save the API Response

Save the API Response ( API Action)

Here via API action, we have retrieved the amount into the proper decimal system. Now hit the “Save” button to save the API response.

Step 9: Setting Action for Stripe with Google Sheets Integration

To make this Stripe-Google Sheets integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select-Google-Sheets

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”.

(b) Click the Connect Button

Click-Connect-G-Sheets

After choosing the application click on the “Connect with Google Sheets” button to move forward.

(c) Authorize Application

Authenticate Application

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.

(d) Map the Fields

Map the Fields

After connecting with your Google account, map all the fields quickly like email, name, etc.

(e) Save and Send Test Request

Send Test Request

Once you are done adding up all field data click on the “Save & Send Test Request” button.

Step 10: Check Response in Google Sheets

Check Response

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.

Conclusion –

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.

You May Also Like to Read –