Documentation

Using IFTTT 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 IFTTT. Syncing your data in this way requires an IFTTT 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 IFTTT and click Create.

    Click Create.

  2. Click Add for the If This step.

    Click Add for the If This step.

  3. Select Webhooks.

    Select Webhooks.

  4. For trigger type, click Receive a web request.

    Select a trigger type.

  5. Enter an Event Name and click Create Trigger.

    Enter an Event Name and click Create Trigger.

  6. Click add for the Then That step.

    Click add for the Then That step.

  7. Select Google Sheets.

    Search for and select Google Sheets.

  8. For action type, click Add row to spreadsheet.

    Click add row to spreadsheet.

  9. Configure the action and click Create Action.

    Configure the action.

    Note

    When connecting a Google account, this opens a window for selecting the desired Google account and granting IFTTT permission to access the account’s files.

  10. Click Continue.

    Click Continue.

  11. Review and click Finish.

    Review and click Finish.

  12. When you finish the process, your Applet is already connected.

    Review and click Finish.

  13. Once created, click the Webhook IconDocumentation and copy the generated webhook URL.

    Click the webhook icon.

    Copy the generated webhook URL.

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