Seamless Integration of Shopia with Google Sheets Using Pabbly Connect

Learn how to automate the addition of new Shopia content to Google Sheets in bulk using Pabbly Connect. Follow this step-by-step tutorial for easy integration.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To automate the addition of new Shopia content to Google Sheets, start by accessing Pabbly Connect. This platform allows for seamless integration of various applications, including Shopia and Google Sheets.

First, sign up for Pabbly Connect if you don’t have an account. After signing in, navigate to the dashboard and click on the ‘Create Workflow’ button. Name your workflow appropriately, such as ‘Shopia to Google Sheets’, and click on the ‘Create’ button to proceed.

2. Setting Up Trigger with Shopia in Pabbly Connect

In this step, you will configure the trigger for your workflow using Pabbly Connect. Click on the trigger section and select Shopia as your trigger application. The trigger event you need to choose is ‘Get Published Content’.

• Search for Shopia in the trigger application list.
• Select the trigger event as ‘Get Published Content’.
• Click on ‘Connect’ and create a new connection.

Once connected, you will need to name this connection, for example, ‘New Test’. This setup allows Pabbly Connect to receive data from Shopia whenever new content is generated.

3. Testing the Connection Between Shopia and Pabbly Connect

After setting up the trigger, it’s essential to test the connection to ensure that data is flowing correctly. Click on the ‘Save and Send Test Request’ button in Pabbly Connect. This action will prompt Pabbly Connect to wait for a response from Shopia.

Next, switch to your Shopia dashboard. Go to the settings, find the connections tab, and locate the connection you just created. Click on ‘Send Test Data’ to send a sample of the generated content to Pabbly Connect. This step verifies that the integration is functioning as expected.

4. Configuring Google Sheets in Pabbly Connect

Now that the trigger is set up, it’s time to configure the action for your workflow. Search for Google Sheets in the action application section within Pabbly Connect. Select the action event as ‘Add New Row’.

• Click on ‘Connect’ and create a new connection with Google Sheets.
• Select the spreadsheet where you want to store the data.
• Map the fields such as title, image, ID, and body from Shopia to the corresponding columns in Google Sheets.

After mapping the fields, click on ‘Save and Send Test Request’ to ensure that the data is correctly added to your Google Sheets.

5. Sending Data in Bulk from Shopia to Google Sheets

With your workflow fully set up, you can now send data in bulk. Go back to your Shopia dashboard and navigate to the documents you’ve generated. Select the documents you want to send and click on the ‘Bulk Actions’ button.

Choose the ‘Send to Another App’ option and select the connection you created in Pabbly Connect. This action will trigger the workflow you set up earlier, sending the selected content to Google Sheets automatically.

Conclusion

In this tutorial, we demonstrated how to integrate Shopia with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of adding new content to your Google Sheets, saving time and effort. This integration allows for efficient data management and tracking of your generated content.