Sheetsu

Introduction

Sheetsu allows you connect Google Sheets to anything - Web, Mobile, IoT or any service's API. 

MoEngage <> Sheetsu

The MoEngage and Sheetsu integration allows you to read and write data to your Google spreadsheet.

Use cases

1. You have a spreadsheet with different campaign message for different users with slight tweaks. You can want to send the exact message (from this spreadsheet) to your users. Using the integration, you can reference the spreadsheet from the MoEngage campaigns to send right messages to your users. 

2. You have some attributes are very specific to a campaign that needs to be send out. This is just a one-time campaign, so you don't want to store these details on MoEngage. You can simply add these attributes to a google spreadsheet. Now reference the sheet using MoEngage content APIs. 

3. You want to keep updating (in near real time) a spreadsheet to keep track of users who perform a specific action on MoEngage. Using the integration, you can set up your sheetsu spreadsheet endpoints in a MoEngage connector campaign.    

Integration

 

PREREQUISITES

  • Ensure you have access to your Sheetsu account. 

Using the integration, you can:

1. Fetch details from a spreadsheet at the run time and use them in your MoEngage campaigns using Content APIs. 

2. Update a spreadsheet in near real-time with the details for a specific user segment or as soon as the user performs as a specific event. 

A) Use data from a spreadsheet in MoEngage campaigns  

Let's say your file has detail on the Message title, message and button name for your users. 

Screenshot_2022-06-29_at_12.42.43_PM.png

Note- In this example, we are using ID to search users. You can use any other attribute such as email id or mobile number to identify a user. 

Step 1: Upload a sheet on Sheetsu 

On your Sheetsu dashboard homepage, 

  1. Click JSON API Screenshot_2022-06-29_at_12.30.10_PM.png
  2. Add your spreadsheet URL Screenshot_2022-06-29_at_12.31.14_PM.png
  3. Click Create JSON API
  4. You can now test if your API is working fine by clicking on Go to your API. 
  5. Copy your sheets API URL. It should look like this -
    https://sheetsu.com/apis/v1.0su/aaac4642f6ab 

 

Step 2: Add Sheetsu as Content API on MoEngage 

You can now reference this URL using MoEngage Content APIs. On your MoEngage dashboard - 

  1. Navigate to Settings >> APIs >> Content API. Click Add. Screenshot_2022-03-08_at_6.21.00_PM.png
  2. Add your Sheetsu name and API URL. Screenshot_2022-06-29_at_12.48.01_PM.png

    API URL
    Enter the following URL. Please note that your sheetsu API URL should be the same as copied from the previous step. 

    https://sheetsu.com/apis/v1.0su/<your sheetsu API url>/search?ID={{UserAttribute['ID']}}

     

  3. Click Save. And you will see your Sheetsu API added in MoEngage. Screenshot_2022-06-29_at_12.48.46_PM.png

Note - You can also test your APIs. Provide a sample ID and click Test. You can your API response and validate.  Screenshot_2022-06-29_at_12.50.57_PM.png

 

Step 3: Using Content API's data in MoEngage 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 Sheetsu Content API configured in Step 2. Screenshot_2022-06-29_at_12.53.54_PM.png
  3. Click done to include the response in your campaigns. 

  4. You can use MoEngage templating language to parse through the API response and use the content in your campaigns.  

B) Write data to spreadsheet using MoEngage Connectors   

Step 1: Upload a sheet on Sheetsu 

Make your sheet available for SheetSu APIs. You can follow the same steps as in A.Step 1 in the previous example.  

Step 2: Add your Sheetsu endpoint in MoEngage connector campaigns 

To create a connector campaign on MoEngage, 

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

Screenshot_2022-02-21_at_10.48.46_PM.png

2. On step 2 of the campaign, 

  • Select method as POST
  • Add Webhook URL as :
    https://sheetsu.com/apis/v1.0db/<your sheetsu API URL>
  • In Headers, use
    Content-Type:application/json
  • In Body, define the keys in your spreadsheet and the values that you want to send out. Screenshot_2022-06-29_at_1.30.17_PM.png

Note- You can refer to the Sheetsu APIs for more details. 

3. At this point, your campaign should be ready to test and send. You can also test your connector configuration using the Test functionality available on Step 2 of Create Connector Campaign. 

Screen_Shot_2022-02-22_at_11.12.42_AM.png

If the data is updated successfully on your spreadsheet, your set-up is good to go. You can go ahead and Publish the campaign.

 

 

 

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