How to Add Stripe Payment Details in Google Sheets Using Pabbly Connect

Learn how to integrate Stripe with Google Sheets using Pabbly Connect. This step-by-step tutorial covers all the necessary actions. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start adding Stripe payment details into Google Sheets, you need to access Pabbly Connect. This powerful automation tool allows you to create workflows that connect different applications without any coding knowledge.

Begin by visiting the Pabbly website. If you’re a new user, click on ‘Sign up for free’ to create an account. Existing users can simply sign in. Once logged in, navigate to the Pabbly Connect dashboard where you can create new workflows to automate your tasks.

2. Creating a Workflow in Pabbly Connect

In this section, we will create a workflow in Pabbly Connect to connect Stripe and Google Sheets. Click on the ‘Create Workflow’ button and enter a name for your workflow, such as ‘Add Stripe Payment Details to Google Sheets’.

• Click on the ‘Create’ button to proceed.
• This will open the workflow window where you can set up triggers and actions.

Set the trigger application to Stripe and select the event ‘New Charge’. This means that every time a new payment is made in Stripe, it will trigger the workflow.

3. Setting Up Stripe in Pabbly Connect

Now, you need to set up Stripe in Pabbly Connect. After selecting Stripe as the trigger app, you will receive a webhook URL. Copy this URL as it will be used to connect your Stripe account.

Next, log into your Stripe account and navigate to the ‘Developers’ section. Click on ‘Webhooks’ and then ‘Add Endpoint’. Paste the copied webhook URL into the endpoint URL field. Make sure to select the event ‘Charge Succeeded’ from the dropdown menu.

• Enter any description you wish (optional).
• Click on ‘Add Endpoint’ to finalize the setup.

Once the endpoint is added, your Stripe account will now send payment details to Pabbly Connect whenever a charge is successful.

4. Adding Google Sheets as an Action in Pabbly Connect

After setting up Stripe, it’s time to add Google Sheets as an action in Pabbly Connect. Click on the action application and select Google Sheets. Choose the action event ‘Add New Row’ to add payment details to your spreadsheet.

You will need to connect your Google Sheets account to Pabbly Connect. Follow the prompts to authorize Pabbly to access your Google Sheets. Once connected, select the spreadsheet and specific sheet where you want to add the payment details.

Map the required fields such as Name, Email, Product, Amount, Payment Method, and Address from the Stripe response. Click on ‘Save and Send Test Request’ to check if the integration works correctly.

Once you verify that the data is being added to Google Sheets correctly, your workflow will be complete.

5. Testing the Integration Workflow

To ensure everything is working, perform a test transaction in Stripe using the payment link for your product. After completing the payment, check your Google Sheets to see if the details have been added correctly.

If the payment amount is correct, the details will show up in your Google Sheets. If the amount does not match your filter criteria, the entry will not be added, confirming that your filter works as intended.

By using Pabbly Connect, you can efficiently manage your Stripe payments and maintain accurate records in Google Sheets. This integration saves you time and helps in tracking your revenue seamlessly.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automatically add Stripe payment details to Google Sheets. This integration streamlines your payment tracking process and enhances your business management capabilities.