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

Learn how to integrate Stripe with Google Sheets using Pabbly Connect to automate payment tracking seamlessly. Follow this detailed tutorial for step-by-step guidance. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Integration

To start adding Stripe payment details in Google Sheets, you need to access Pabbly Connect. Simply visit the Pabbly website and log in to your account. If you are a new user, you can sign up for free, which provides you with 100 tasks monthly.

Once logged in, navigate to the dashboard and click on the Pabbly Connect application. Here, you will see an option to create a new workflow. This is the foundation for connecting Stripe and Google Sheets.

Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the ‘Create Workflow’ button. You will need to name your workflow, such as ‘Add Stripe Payment Details to Google Sheets,’ and select a folder for organization. After naming, click on the ‘Create’ button to proceed.

This action opens the workflow window, where you will set up the trigger and action. The trigger is the event that starts the workflow, while actions are the tasks performed as a result of the trigger.

• Name your workflow appropriately.
• Select a folder for organization.
• Click on ‘Create’ to open the workflow window.

Now, you can select the trigger application, which will be Stripe. This means that whenever a new payment is made in Stripe, it will trigger the workflow to add the payment details to Google Sheets.

Setting Up the Trigger with Stripe

In the workflow window, select Stripe as the trigger application. Choose the trigger event as ‘New Charge’. Pabbly Connect will generate a webhook URL, which you need to copy for the next steps.

Next, log in to your Stripe account and navigate to the Developers section. From there, go to the Webhooks section and click on ‘Add Endpoint’. Paste the copied webhook URL into the endpoint URL field. Select the event ‘Charge Succeeded’ to listen for successful payments.

• Navigate to the Developers section in Stripe.
• Go to the Webhooks section and select ‘Add Endpoint’.
• Paste the webhook URL and select ‘Charge Succeeded’ event.

After setting this up, click on ‘Add Endpoint’ to finalize the connection between Stripe and Pabbly Connect. This will allow Stripe to send payment details to your Pabbly workflow.

Testing the Integration

To ensure that the integration works correctly, perform a test submission. Open the payment link for the course you are selling and fill in the required details, such as email, name, and payment information. Once you click on pay, Stripe will process the transaction.

After completing the test payment, return to your Pabbly Connect workflow. You should see that it has captured the response from Stripe, including details like the name, email, amount, and payment method. If the details appear correctly, your integration is functioning as intended.

Fill in the payment link with dummy details. Complete the payment process. Check if Pabbly Connect captured the response.

Once the test is successful, you can proceed to add further actions to your workflow, ensuring that you have a complete automation process set up.

Adding Payment Details to Google Sheets

Now that you have successfully tested the trigger, it’s time to add the payment details to Google Sheets. In your Pabbly Connect workflow, add a new action and select Google Sheets as the application. Choose the action event as ‘Add New Row’.

You will need to connect your Google Sheets account with Pabbly Connect. If you haven’t connected it yet, follow the prompts to sign in and allow necessary permissions. Once connected, select the spreadsheet and sheet where you want to add the payment details.

Select Google Sheets as the action application. Choose ‘Add New Row’ as the action event. Map the fields from Stripe to the corresponding columns in Google Sheets.

Map the fields such as name, email, product, amount, and address to the respective columns in your Google Sheets. After mapping, click on ‘Save and Send Test Request’ to ensure the details are added correctly. You can then check your Google Sheets to confirm that the payment details have been recorded.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to seamlessly integrate Stripe with Google Sheets for automatic payment tracking. By following the steps outlined, you can efficiently manage and analyze your payment data without any coding knowledge. This integration not only saves time but also enhances your business operations.