Import Missive API Data to Google Sheets

In this guide, we’ll walk through how to pull data from the Missive API directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

• Before You Begin
• Part 1: Get Missive API Key
• Part 2: Pull Missive API Data into Sheets
• Part 3: API Documentation

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Missive API Key

1. Open the Missive app, click over your name in the footer to open the menu, and navigate to Settings > API
   
   
2. You should be in the "Tokens" tab. Click New token
   
   
3. Give your token a name and click Create
   
4. You'll now see your token. Copy it and keep it safe as we'll use it shortly.
   
   

Part 2: Pull Missive API Data into Sheets

You can fetch data from any of the endpoints shown in the documentation. For this example we'll fetch preset responses. Substitute in your own token where it says your_token.

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: GET
   • Request URL: https://public.missiveapp.com/v1/responses
   • Headers:
     • Authorization: Bearer your_token
3. Create a new tab and click Set current to use that tab as your data destination.
4. Name your request and click Run. A moment later you’ll see your saved responses populate your sheet.
   

Part 3: API Documentation

Official API documentation: https://missiveapp.com/help/api-documentation/rest-endpoints