Integrating Moxy with Google Sheets Using Pabbly Connect: A Step-by-Step Guide

Learn how to seamlessly integrate Moxy with Google Sheets using Pabbly Connect. Follow our detailed tutorial for automating your workflow! Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Moxy with Google Sheets, you need to access Pabbly Connect. Begin by opening a new tab and searching for Pabbly’s website. If you don’t have an account, sign up for free which takes just two minutes. Existing users can sign in directly to access their dashboard.

Once logged in, locate the section for Pabbly Connect on the dashboard. Click on the ‘Access Now’ button to enter the workflow area. Here, you can create a new workflow tailored to your needs.

2. Creating a New Workflow in Pabbly Connect

In this step, you will create a workflow that captures Moxy form submissions and automatically adds them to Google Sheets using Pabbly Connect. Click on the ‘Create Workflow’ button and name your workflow accordingly, for example, ‘Add Google Sheets Row for Moxy Form Submission’.

• Select a folder to save your workflow.
• Click on ‘Create’ to proceed.

This will lead you to the workflow window where you will set up the trigger and action. The trigger will be Moxy, and the action will be Google Sheets.

3. Setting Up the Trigger for Moxy

Setting up the trigger is crucial in Pabbly Connect. Search for Moxy in the trigger application section and select it. For the trigger event, choose ‘Form Submitted’. This event will activate every time a form is submitted in Moxy.

To connect Moxy with Pabbly Connect, you will need to use a VB URL. Copy the given URL and navigate to Moxy’s workspace settings. Under the Connected Apps section, find the integration for Pabbly Connect and add a REST hook.

• Select the event type as ‘Form Submitted’.
• Paste the copied URL in the endpoint field.
• Click on ‘Save’ to finalize the connection.

After saving, you can proceed to the form builder in Moxy to test your setup.

4. Adding Data to Google Sheets via Pabbly Connect

Now that the trigger is set up, the next step involves adding the captured data to Google Sheets through Pabbly Connect. Search for Google Sheets in the action application section and select it. The action event you want is ‘Add New Row’.

Connect your Google Sheets account by clicking on ‘Add New Connection’ and signing in. Make sure to allow permissions for Pabbly Connect to access your Google Sheets. Once connected, select the spreadsheet where you want to store the data.

Choose the spreadsheet named ‘Moxy Form Submission’. Map the fields from Moxy to the respective columns in Google Sheets.

Ensure that the first name, last name, and email fields are correctly mapped. Finally, click on ‘Save and Test Request’ to verify that the integration works as intended.

5. Testing the Integration with Dummy Data

With the integration set up, it’s time to test it. Fill out the Moxy form with dummy data, such as a first name, last name, and email. Once submitted, return to Pabbly Connect to check if the data has been captured.

After submitting the form, you should see the new response in Pabbly Connect. To confirm that the data has been added to Google Sheets, check the spreadsheet. You should see a new row with the submitted details.

Repeat the process with different dummy data to ensure consistency. Verify that each submission correctly updates the Google Sheets.

This confirms that your integration between Moxy and Google Sheets via Pabbly Connect is functioning successfully.

Conclusion

In this tutorial, we explored how to integrate Moxy with Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the process of adding Google Sheets rows for form submissions efficiently. This integration streamlines your workflow, making data management easier and more organized.