How to Add a New Row in Google Sheets on New Submission in Carrd Using Pabbly Connect

Learn how to automate adding new rows in Google Sheets for new submissions in Carrd using Pabbly Connect. Follow our detailed step-by-step tutorial. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Start Integration

To automate the process of adding new rows in Google Sheets for new submissions in Carrd, you first need to access Pabbly Connect. Begin by visiting the Pabbly website where you can either sign in or sign up for a free account. Signing up grants you free tasks every month, which is beneficial for testing your automation.

Once logged in, click on the ‘Create Workflow’ button located at the top right corner. You will be prompted to name your workflow. Enter a name like ‘Carrd to Google Sheets’ and create the workflow. This sets up the foundation for your automation using Pabbly Connect.

2. Set Up Trigger Event in Pabbly Connect

In this step, you will configure the trigger event in Pabbly Connect. A trigger is an event that starts the automation process. Select ‘Carrd’ as your trigger application and choose the ‘New Submission’ event. This event will activate whenever there is a new submission in your Carrd form.

• Choose ‘Carrd’ as the trigger application.
• Select ‘New Submission’ as the trigger event.
• Copy the generated webhook URL for the next steps.

After selecting the trigger, a webhook URL will be generated. This URL is crucial as it connects Carrd with Pabbly Connect. You will need to paste this URL into your Carrd form settings to complete the trigger setup.

3. Configure Your Carrd Form with Pabbly Connect

Next, navigate to your Carrd account to configure the form that will send data to Pabbly Connect. Open the form you want to use and set the type to ‘Custom’. Then, select ‘Send to URL’ from the dropdown menu. This will allow you to send the form data to the webhook URL you copied earlier.

• Set the form type to ‘Custom’ in Carrd.
• Select ‘Send to URL’ from the dropdown options.
• Paste the webhook URL into the URL field.

After pasting the URL, click on the ‘Done’ button and then publish the changes to your Carrd site. This step ensures that your form is now connected to Pabbly Connect and ready to send data upon submission.

4. Test the Integration with a Dummy Submission

Once the Carrd form is set up, it’s time to test the integration. Go back to Pabbly Connect and check if it’s waiting for a webhook response. Now, go to your Carrd form and submit a test entry with dummy details. This could include a name, email, and contact number.

After submitting the form, return to Pabbly Connect to see if it captured the response from your test submission. If successful, you will see the details displayed, confirming that the integration is working correctly.

5. Add New Row in Google Sheets for Each Submission

In this final step, you will configure the action event in Pabbly Connect to add a new row in Google Sheets. Select ‘Google Sheets’ as your action application and choose the ‘Add New Row’ action event. This ensures that every new submission from Carrd will create a corresponding entry in your Google Sheets.

Connect your Google Sheets account and select the specific spreadsheet where you want the data to be added. Map the fields from your Carrd submission to the corresponding columns in Google Sheets, such as name, email, and contact number. Once everything is set, click on ‘Save and Send Test Request’ to finalize the setup.

Conclusion

By following these steps, you can successfully automate the process of adding new rows in Google Sheets for every new submission in Carrd using Pabbly Connect. This integration streamlines your workflow and ensures that all your submissions are recorded in one place, enhancing your data management efficiency.