How to Sync New Stripe Orders with Google Sheets Using Pabbly Connect

Learn how to sync new Stripe orders with Google Sheets using Pabbly Connect. This detailed tutorial guides you through the exact steps for seamless integration.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin syncing new Stripe orders with Google Sheets, you need to access Pabbly Connect. Start by navigating to the Pabbly Connect homepage by entering ‘Pabbly.com/connect’ in your browser.

Once on the homepage, you will see options to either sign in or sign up. If you’re new to Pabbly Connect, click on ‘Sign Up Free’ to create an account and receive 100 free tasks monthly. Existing users should click on ‘Sign In’ to access their account.

2. Creating a Workflow in Pabbly Connect

After signing in, you will be directed to the Pabbly Apps window. From here, click on Pabbly Connect to access the dashboard. To create a new workflow, click on the ‘Create Workflow’ button located at the top right corner.

• Select the workflow builder (choose between the new beta version or classic).
• Name your workflow, e.g., ‘Sync New Stripe Orders with Google Sheets’.
• Select a folder to save your workflow.

Once you have set up your workflow, click on the ‘Create’ button to proceed. This initiates the automation process where you will set up the trigger and action steps.

3. Setting Up the Trigger for Stripe Payments

In this step, you will configure the trigger that will activate the workflow. Click on the ‘Add Trigger’ button and select Pabbly Connect as the trigger application. Choose ‘New Charge’ as the event.

After selecting the event, you will receive a webhook URL. Copy this URL, as it will be used to connect your Stripe account with Pabbly Connect. Log in to your Stripe account, navigate to the ‘Developers’ section, and select ‘Webhooks’ to set up a new webhook using the copied URL.

• Click on ‘Add Endpoint’ in Stripe Webhooks.
• Select ‘Charge Succeeded’ as the event to listen for.
• Paste the webhook URL in the endpoint URL field and click ‘Create Destination’.

With the webhook set up, return to Pabbly Connect and proceed to test the connection by making a test payment in Stripe.

4. Configuring the Action Step in Google Sheets

After successfully setting up the trigger, it’s time to configure the action step that will add new order details to Google Sheets. In Pabbly Connect, click on ‘Add Action’ and select Google Sheets as the action application. Choose ‘Add a New Row’ as the event.

Next, connect your Google Sheets account by clicking ‘Sign in with Google’. Select your account and allow access to Pabbly Connect. Once connected, select the spreadsheet where you want to store the order details.

Choose the spreadsheet you created for Stripe payments. Select the specific sheet within the spreadsheet. Map the fields such as name, email, amount, and payment method from the Stripe response.

After mapping the required fields, click on ‘Save and Send Test Request’ to finalize the action. Verify that the new order details appear in your Google Sheets.

5. Finalizing the Integration and Testing

With both the trigger and action steps configured, your integration between Stripe and Google Sheets via Pabbly Connect is nearly complete. To ensure everything is working correctly, conduct a test payment in your Stripe account.

Check your Google Sheets to confirm that the order details have been added as a new row. If the details appear correctly, your automation is functioning as intended. You can now seamlessly sync new Stripe orders with Google Sheets using Pabbly Connect.

In summary, this integration allows you to automate the process of recording new Stripe orders in Google Sheets, enhancing efficiency and accuracy in your business operations.

Conclusion

By following this tutorial, you have learned how to sync new Stripe orders with Google Sheets using Pabbly Connect. This powerful integration streamlines your order management process, ensuring that every payment is recorded accurately and efficiently.

Utilizing Pabbly Connect not only saves time but also minimizes the risk of errors in data entry. Now you can focus on growing your business while Pabbly Connect handles the automation for you.