Track New Sales Orders from Stripe to Google Sheets Using Pabbly Connect

Learn how to track new sales orders from Stripe to Google Sheets using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To track new sales orders from Stripe to Google Sheets, you need to access Pabbly Connect. Start by visiting the Pabbly website and navigating to the Connect section. Here, you will find options to either sign in or create a new account if you are a first-time user.

Once you have logged into your Pabbly Connect account, you will see the dashboard, which includes various applications available for integration. To begin the process, click on the ‘Create Workflow’ button located in the top right corner of the dashboard.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a workflow that connects Stripe and Google Sheets using Pabbly Connect. After clicking on ‘Create Workflow’, you will be prompted to name your workflow. For this integration, name it ‘Track New Sales Orders from Stripe to Google Sheets’.

• Select the folder where you want to save this workflow.
• Choose the ‘Stripe’ application as your trigger.
• Set the trigger event to ‘New Charge’ to capture new sales orders.

After selecting these options, click on the ‘Connect’ button. This will generate a webhook URL that you will use to connect your Stripe account with Pabbly Connect. Make sure to copy this URL as it will be needed in the following steps.

3. Setting Up Stripe for Webhooks

The next step involves setting up your Stripe account to send data to the webhook URL generated by Pabbly Connect. Log in to your Stripe account and navigate to the Developers section in the sidebar. Here, click on ‘Webhooks’ to add a new webhook.

• Click on ‘Add endpoint’ and paste the copied webhook URL from Pabbly Connect.
• Select the event type as ‘charge.succeeded’ to ensure you capture successful transactions.
• Save the webhook settings.

With the webhook set up, any new sales orders processed through Stripe will trigger data to be sent to Pabbly Connect, allowing you to automate the data entry into Google Sheets.

4. Configuring Google Sheets for Data Entry

Now that you have set up your Stripe account, it’s time to configure Google Sheets to receive the data. In your Pabbly Connect workflow, add a new action step and select ‘Google Sheets’ as the application.

Choose the action event as ‘Add Row’ and connect your Google Sheets account by clicking on ‘Sign in with Google’. Select the spreadsheet where you want the sales order details to be stored. Map the fields from the Stripe data to the corresponding columns in your Google Sheets, such as Name, Email, Amount, and Payment Method.

5. Testing the Integration

With everything set up, it’s crucial to test the integration to ensure data flows correctly from Stripe to Google Sheets via Pabbly Connect. Go back to your Stripe account and make a test payment using the test mode.

After completing the test payment, check your Google Sheets to see if the new row with the order details has been added successfully. If the integration is working correctly, you will see the name, email, amount, and payment method populated in the sheet.

Conclusion

In this tutorial, we demonstrated how to track new sales orders from Stripe to Google Sheets using Pabbly Connect. By following these steps, you can automate the process of recording sales orders efficiently. This integration not only saves time but also ensures that your sales data is organized and easily accessible.