With Sheetgo, you can connect AWS RDS (Relational Database Service) data to Google Sheets by using an API layer that exposes your database data via HTTP endpoints. Since AWS RDS itself does not provide a direct REST API for querying data, you can use AWS services like API Gateway combined with Lambda to create an API interface. This allows you to extract structured data such as customer records, transactions, logs, or analytics directly into Google Sheets for reporting, monitoring, and automation, improving visibility and decision-making across your business.
Prerequisites
AWS Account with RDS instance configured
AWS API Gateway + Lambda setup to expose RDS data as an API
IAM permissions to access RDS and API Gateway
API endpoint URL created via AWS API Gateway
Authentication method (API Key, IAM Auth, or Bearer Token depending on setup)
AWS Documentation for RDS and API Gateway: https://docs.aws.amazon.com/
AWS Lambda Documentation: https://docs.aws.amazon.com/lambda/
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
To connect AWS RDS with Sheetgo, you first need an HTTP API endpoint that exposes your database data. Since RDS is a database service, you must create an API using AWS API Gateway connected to a Lambda function that queries your RDS database. In the AWS documentation linked in the Prerequisites, locate how to create an API Gateway endpoint and connect it to Lambda. The endpoint will typically look like a URL that returns JSON data from your database query, such as retrieving rows from a table like users or orders.
Step 2: Generate API Credentials
Once your API Gateway endpoint is created, you need to configure authentication. Depending on your setup, AWS may require an API key, IAM-based authorization, or a Bearer token. In the AWS console, navigate to API Gateway and generate an API key if required, then associate it with your deployed API stage. If using IAM or token-based authentication, follow the credential generation process described in the documentation linked in the Prerequisites. Ensure that your credentials are securely stored, as they will be used in the Sheetgo request headers.
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 source. Paste your API Gateway endpoint URL into the request field. Then configure the headers to authenticate and paginate your data. Since most APIs return data in pages, you must include pagination configuration inside the headers JSON. Below is an example structure you can adapt based on your AWS API response format:
{
"Authorization": "Bearer YOUR_API_TOKEN",
"Content-Type": "application/json",
"x-api-key": "YOUR_API_KEY",
"@pagination": {
"type": "page",
"page_param": "page",
"per_page_param": "limit"
}
}If your API uses token refresh (for example via OAuth or custom token logic), you can include a refresh configuration in the same header structure as described in the documentation provided in the Prerequisites. Sheetgo supports pagination and authentication through headers to ensure complete data retrieval across multiple pages.
Step 5: Choose the Destination Spreadsheet
After configuring the API request, proceed to the next step in Sheetgo and select your destination. You can either create a new Google Sheet or choose an existing one where your AWS RDS data will be stored. This sheet will automatically structure the JSON response into tabular format, making it easy to analyze and report.
Step 6: Execute the Sheetgo Connection
Finally, run the workflow to execute the API request and import your AWS RDS data into Google Sheets. Once the data is successfully loaded, you can schedule automatic refreshes within Sheetgo to keep your spreadsheet updated in real time. This ensures continuous synchronization between your AWS database and reporting dashboards without manual intervention.