Documentation

Using Pabbly to Sync Object Data with Google Sheets

Available 7.4+

Here you’ll learn how to use webhooks to trigger sync tasks between Liferay Objects and Google Sheets using Pabbly. Syncing your data in this way requires an Pabbly account, Google Spreadsheet, and active DXP 7.4 instance. The DXP instance must also have a published Object with the desired fields for sending or receiving data to the Google Spreadsheet.

Syncing Object Data to a Google Sheet

Follow these steps to sync Object data to a Google Sheet:

  1. Sign in to Pabbly, navigate to the All Apps page, and click Pabbly Connect.

    Navigate to the All Apps page and click Pabbly Connect.

  2. On the Dashboard page, click Create Workflow.

    Click Create Workflow.

  3. Enter a name and click Create.

    Choose a name and click Create.

  4. For the Trigger, select the Webhook app.

    Search for and select the Webhook app.

  5. Copy the generated webhook URL.

    Copy the generated webhook URL.

  6. In your Liferay instance, use the copied URL to define an Object action that sends a request to the webhook endpoint whenever a new Object entry is added.

    Define an action that sends a request to the webhook endpoint whenever an entry is added.

  7. Adding an Object entry to trigger the webhooko and then click Capture Response in Pabbly.

    This allows the Webhook app to determine the Object’s data structure automatically.

    Trigger the webhook.

  8. For the Action, select the Google Sheets app.

    Select the Google Sheets app.

  9. In the Action Event dropdown menu, select Add New Row and click Connect.

    Select Add New Row.

  10. Connect the desired Google account to the app and click Save.

    Connect the desired Google account.

  11. Select the desired Spreadsheet and Sheet to sync with the Object.

    Select the desired Spreadsheet and sheet to sync with the Object.

  12. Map the Sheet’s columns to data fields in the Object’s structure.

     Map the Sheet's columns to data fields in the Object's structure.

  13. Click the Save & Send Test Request button and verify the test was successful.

    Click the Save & send Test Request.

    If successful, the Workflow is activated and ready to use.