With Sheetgo, you can connect your Monday.com account directly to Google Sheets to automatically import board data, items, updates, or activity logs. This integration allows you to track project progress, KPIs, and resource allocation across multiple teams in real time. By automating Monday.com data imports into spreadsheets, you can create dynamic dashboards and eliminate manual reporting tasks.
Prerequisites
- A Monday.com account with admin or board access.
- A Monday.com API Token.
- Access to the Monday GraphQL API documentation: https://developer.monday.com/api-reference.
- A Sheetgo account linked to the same email used in your Monday.com account.
Step 1: Identify the Required API Endpoint
Monday.com uses a GraphQL API instead of traditional REST endpoints. Visit the Monday.com API documentation linked above and explore the “Reference” section to review available queries. For example, to retrieve all board IDs and names, you can use the following GraphQL query: { boards { id name } }. In Sheetgo, this GraphQL query must be encoded to fit into a GET request.
Step 2: Generate API Credentials
Log in to your Monday.com account and click on your profile picture in the bottom-left corner. Go to Administration → Connections → API, then click Generate Token. Copy your token and keep it secure, as it provides full access to your account’s data through the API.
Step 3: Open the Sheetgo API Connector
Log in to Sheetgo and open an existing workflow or create a new one. Click on Connect and choose API Request under Data Source. Then select HTTP Request as the method type. You’ll be prompted to enter the API URL and configure authentication and headers.
Step 4: Configure the API Request in Sheetgo
In Sheetgo, create a new workflow and choose HTTP Request as your data source. Since Monday.com uses GraphQL queries, you’ll need to encode your query as a URL parameter. Then, in the Headers field, paste the following JSON configuration:
{
"Authorization": "Bearer YOUR_API_TOKEN",
"Content-Type": "application/json",
"@pagination": {
"type": "cursor",
"cursor_param": "page",
"next_cursor_key": "data.next"
}
}This header authorizes your request and defines cursor-based pagination, allowing Sheetgo to fetch all results automatically if Monday’s API returns multiple pages.
Step 5: Choose the Destination Spreadsheet
Select or create a Google Sheet where your Monday.com data will be stored. You can organize your columns to match the data fields from your GraphQL query (e.g., board ID, board name). Each Sheetgo refresh will overwrite or append new data, depending on your configuration.
Step 6: Execute the Sheetgo Connection
Click Run to execute your API connection. Sheetgo will retrieve your Monday.com data via the GraphQL query and populate your spreadsheet. Once successful, set up an automated schedule (hourly, daily, or weekly) to keep your board data synced in real time for continuous tracking and reporting.