Documentation

Using Wyzebulb 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 Wyzebulb. Syncing your data in this way requires an Wyzebulb 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. Log in to Wyzebulb and create a Flow.

  2. For the trigger, select the Webhooks app.

    Select an App for the trigger.

    Select Webhooks.

  3. Select the Catch Hook trigger and click Save + Continue

    Select the Catch Hook trigger.

    Click Save and Continue.

  4. Click Webhooks URL and copy the generated URL.

    Select the Webhooks URL.

    Copy the Webhook URL.

  5. 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.

  6. Add a test Object entry to trigger the webhook.

    This allows the Webhooks module to determine the Object’s data structure automatically.

  7. Verify the test was successful and click Save + Continue.

    Successful Test.

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

    Click App to select an app.

    Select Google Sheets.

  9. Select the Create a new row in Google Sheets action and click Save + Continue

    Click Action to select an action.

    Select Create a new row in Google Sheets.

  10. Connect the Google Sheets app to a Google account.

    Connect the Google Sheet app to a Google account.

  11. Select the desired Spreadsheet and Worksheet.

    Select the desired Spreadsheet and Worksheet.

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

    Map the Sheet's columns to Object fields.

  13. Click the Test Action button and verify the test was successful.

    Successful Test.

  14. Navigate to My Flows page and verify your flow is running.

    Verify your flow is running.