With Sheetgo, you can connect Tinybird to Google Sheets and automatically retrieve real-time analytics data stored in Tinybird APIs. Tinybird is designed for fast data ingestion and querying using APIs, which makes it ideal for extracting event data, user activity, metrics, and time-series analytics directly into spreadsheets. By integrating Tinybird with Sheetgo, you can automate reporting, monitor KPIs, and centralize your analytics data in Google Sheets without manual exports.
Prerequisites
Tinybird account
Tinybird Workspace with Data Sources and Endpoints created
Tinybird API Token (Auth Token)
Tinybird Endpoint URL (Pipe Endpoint)
Tinybird API Documentation: https://www.tinybird.co/docs
Tinybird Authentication Guide: https://www.tinybird.co/docs/api-reference/authentication.html
Sheetgo API Connector Guide: https://support.sheetgo.com/en/articles/8529746-how-to-connect-an-api-to-a-spreadsheet
Step 1: Identify the Required API Endpoint
In Tinybird, data is accessed through API endpoints called Pipes. To retrieve data, you need to identify the correct Pipe endpoint that returns the dataset you want, such as analytics metrics or event data. Navigate to your Tinybird workspace and open the Pipe you want to use. In the API section of that Pipe, you will find a GET endpoint URL. This endpoint is what you will use in Sheetgo to fetch your data, and you can customize it with query parameters to filter or limit results as explained in the documentation linked in the Prerequisites.
Step 2: Generate API Credentials
Tinybird uses authentication tokens to authorize API requests. To generate your API token, go to your Tinybird dashboard and navigate to the Tokens section. Create a new token or copy an existing one with read permissions for your Pipe endpoint. This token will be used as a Bearer token in the request headers. Refer to the authentication documentation linked in the Prerequisites for detailed steps on generating and managing tokens securely.
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
Open Sheetgo and create a new workflow using the HTTP Request option. Paste your Tinybird Pipe endpoint URL into the request field. Then configure the headers to include your authentication token and pagination settings. Tinybird supports query parameters like limit and offset for pagination, so you can configure it accordingly in Sheetgo. Use the following JSON structure as an example:
{
"Authorization": "Bearer YOUR_TINYBIRD_API_TOKEN",
"Content-Type": "application/json",
"@pagination": {
"type": "offset",
"offset_param": "offset",
"limit_param": "limit"
}
}This configuration ensures that Sheetgo retrieves all available data across multiple pages. If your endpoint includes additional query parameters, append them directly to the request URL as described in the documentation linked in the Prerequisites.
Step 5: Choose the Destination Spreadsheet
After setting up the API request, proceed to select your destination. Choose an existing Google Sheet or create a new one where your Tinybird data will be imported. Sheetgo will automatically map the JSON response into rows and columns for easy analysis.
Step 6: Execute the Sheetgo Connection
Finally, run the workflow to execute the API request and import your Tinybird data into Google Sheets. Once the data is loaded, you can schedule automatic refreshes in Sheetgo to keep your reports updated with the latest analytics data. This enables continuous monitoring and eliminates the need for manual data extraction.