Sheetlabs

Introduction

Sheetlabs is a platform that allows you to turn spreadsheets into powerful, well-documented APIs.

MoEngage <> Sheetlabs

Sheetlabs help you use Google Sheets as a simple CSM that can be then used to provide dynamic content for the campaigns you send out in MoEngage. 

Integration

library_add_check

Prerequisites

  • Ensure you have access to your Sheetlabs account.

Step 1: Import your table in Sheetlabs

You can either import your Excel document or connect your Google Account to import Google Sheets.

On your Sheetlabs dashboard, go to Data Tables menu.

  • To Import from your Google account, click on "Import from Google Sheets". You can then connect your Google account and grant Sheetlabs relevant permissions. Sheetlabs also provides an option to keep the data in your tables synced.
  • To Import from CSV or Excel, click on "Import data table from CSV or Excel".

Step 2: Create an API in Sheetlabs

Step2-API.png

  1. On your Sheetlabs Dashboard, go to the APIs menu.
  2. Select the data table you want to create an API for.
  3. Give the API a name, and a description.
  4. You can set up GET API to fetch data and also write APIs to insert data.

Step 3: Configure MoEngage Content APIs

Use MoEngage Content APIs to add Sheetlabs as one of your feeds. You can add multiple APIs from Sheetlabs at the same time for each use case.

Setting up the API

info

Information

We've revamped our dashboard settings UI. Content API is now available in Settings -> Advanced Settings -> Content API in the revamped UI. For more information, refer to Summary of Changes - Settings UI Revamp.

  1. Revamped UI Old UI

    Navigate to Settings -> Advanced Settings -> Content API. Click + Add content API at the top right corner of the Content API screen.

    ContentAPI_Navogation.png

  2. Add your Sheetlabs API to the endpoint URL.

API URL

Once the API is set up, you can find its endpoint ("Base URL") on the API Details page:

Step3-APIDetails.png

  1. Enter the headers and parameters that you set up while configuring Sheetlabs. You can also use personalised values by typing "@".

    Step3B-ContentAPI.png

  2. Click Save. Now, you will see your Sheetlabs API added in MoEngage.

    Note - You can also test your APIs by clicking on the Test button. You can test your API response and validate.

    Step3C-ContentAPITesting.png

Step 4: Fetch data using Content APIs in Campaigns

You can now use these content APIs in your campaigns. Read here to know more about Content APIs.

  1. On step 2 on your campaign creation, enter @.
  2. In the pop up, you can select the Content API configured in Step 2.
  3. You can use MoEngage Templating Language to parse through the API response and use the content in your campaigns.

Use MoEngage Connector Campaign to push data to your Sheets

To create a connector campaign on MoEngage, 

1. Navigate to Create Campaign >> Connectors >> Custom and choose the delivery type most suitable to your needs

Screenshot_2022-02-21_at_10.48.46_PM.png

2. On step 2 of the campaign 

Send data using SheetLabs API

To create a new record, use the POST method and supply an array with one or more records in JSON format.

  • Select the method as POST
  • Add base URL as Webhook URL

Step4-ConnectorCampaign.png

  • Select Body-type as "JSON" and add key-value pairs accordingly. Refer to the Sheetlabs documentation for more information.

Preview your request 

At this point, your campaign should be ready to test and send. You can also test your connector configuration using the Test functionality available in Step 2 of Create Connector Campaign.Screen_Shot_2022-02-22_at_11.12.42_AM.png

You can go ahead and Publish the campaign.

Previous

Next

Was this article helpful?
0 out of 0 found this helpful

How can we improve this article?