Print

Import Monday Data to Google Sheets

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

We'll first get an API token from Monday, and then set up a request to pull in data from Monday to your spreadsheet.

Contents

Before You Begin

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

Part 1: Get Your Monday API Token

  1. Log in to Monday and click the avatar menu > Developers from the lower left corner
    monday-developers
  2. From the Developers page, click Developer > My Access Tokens
    monday-token
  3. On the screen that appears, generate an API token by clicking Generate
    clickup-generatetoken
  4. You should now see your token. Copy and keep it handy as you'll need it in a moment. Congrats! You're now ready to use the Monday API.
    monday-copytoken

Part 2: Get your Monday Board ID

Many queries will require that you include your board ID, so let's get that now. While logged into Monday, navigate to your board. The board ID will be shown in the URL bar.

Part 3: Pull Monday API Data into Sheets

We'll now get the items from the board. Substitute in your own board ID where it says your_board_id, and your own API token where it says your_api_token

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodPOST
    • Request URLhttps://api.monday.com/v2
    • Headers:
      • Authorizationyour_api_token
    • Request body: { "query": "{boards(ids:your_board_id) { items {id name column_values {id title value}}}}" }
  3. Under Output options, set the Report style to grid
  4. Monday's API doesn't send data back in a format that works well with Sheets, so let's clean it up a bit. Still under Output options, enable the Flatten field to header option with these settings:
    • Path to header: data.boards.items.column_values.title
    • Path to value: data.boards.items.column_values.value
  5. Create a new tab and click Set current to use that tab as your data destination.
  6. Name your request and click Run. A moment later you’ll see tasks from your board populate your sheet.
    monday-response

The Monday API is a GraphQL API. This means the request URL always stays the same, while the data response is defined via the request body. Check the API documentation for the full list of available data points.

Part 4: API Documentation

Official API documentation: https://developer.monday.com/api-reference/docs

Leave a Comment

Jump To