How to Integrate Elopage Payments with Google Sheets Using Pabbly Connect

Learn how to automate the integration of Elopage payments into Google Sheets using Pabbly Connect with this 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. Setting Up Pabbly Connect for Elopage Payments

To begin integrating Elopage payments into Google Sheets, you need to access Pabbly Connect. This platform serves as the automation solution that connects various applications seamlessly. First, create a Pabbly Connect account by signing up via the provided link in the description.

After signing up, log in to your Pabbly Connect dashboard. Click on the ‘Create Workflow’ button to initiate the integration process. Name your workflow something like ‘Elopage Payments to Google Sheets’ and click the ‘Create’ button to proceed.

2. Configuring Elopage as the Trigger Application

In this step, you will set up Elopage as the trigger application in Pabbly Connect. Under the trigger section, select Elopage from the app dropdown menu. The event that will trigger this workflow is ‘Any New Payment Captured’.

Click on the connect button and choose to add a new connection. You will be prompted to enter the API Key and API Secret Key from your Elopage account. These keys can be found in the settings under the Integrations section of your Elopage dashboard.

• Navigate to the settings icon in your Elopage dashboard.
• Under Technical Setup, find the Integrations option.
• Copy the API Key and Secret Key for use in Pabbly Connect.

Once you have entered the keys, save the connection. You will then need to perform a test payment to capture the data for mapping.

3. Performing a Test Payment

After setting up the trigger, it’s time to perform a test payment. This step is crucial as it allows Pabbly Connect to capture the payment data that will be sent to Google Sheets. Open the payment page you created in Elopage for your product.

Fill in the required details for a demo customer and complete the payment. Since this is a test, you can set the product price to zero. After the payment is processed, Pabbly Connect should display the captured payment details in the response section.

• Ensure that the payment details include product ID, product name, and customer information.
• Verify that the status of the payment is marked as paid.

These details will be used in the next steps to map the data into Google Sheets.

4. Adding Payment Data to Google Sheets

Now that you have captured the payment details, the next step is to configure Google Sheets as the action application in Pabbly Connect. Search for Google Sheets in the action step and select the ‘Add New Row’ option.

Click on the connect button and sign in with your Google account. Ensure that you grant the necessary permissions for Pabbly Connect to access your Google Sheets. Select the spreadsheet where you want to store the payment details.

Choose the spreadsheet named ‘Elopage Payments’. Map the fields such as product name, purchase date, first name, last name, and email address using the data captured from the Elopage trigger.

After mapping the data, click on ‘Save and Send Test Request’ to verify the connection. A new row should be added to your Google Sheet with the payment details.

5. Finalizing the Integration Workflow

With the payment data successfully added to Google Sheets, you can finalize your workflow in Pabbly Connect. This integration will run in the background, automatically updating your Google Sheet with new payment details whenever a sale is made on Elopage.

You only need to set up this workflow once, and it will handle all future payments automatically. You can also clone this workflow for other products or services as needed by using the link provided in the description.

With this setup, you can efficiently manage your payment records without manual entry, saving you valuable time.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the integration of Elopage payments into Google Sheets. This process not only streamlines your workflow but also ensures that your payment records are always up-to-date without manual input. By following these steps, you can easily set up your own automation and enhance your productivity.