--- title: "Athena Connector to Google Sheets Reporting System | OWOX" canonical: "https://www.owox.com/connectors/aws-athena-connector-to-google-sheets" updated: "2026-10-30" --- # Enable business reporting from your AWS Athena data Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Google Sheets. ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%3E%3Cpath%20d%3D%22M48%2029.0142L24%2026.0256L0%2029.0142L24%2048L48%2029.0142Z%22%20fill%3D%22%23FCBF92%22%2F%3E%3Cpath%20d%3D%22M0%2029.0142L24%2036.2676V48L0%2035.8398V29.0142Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M48%2029.0142L24%2036.2676V48L48%2035.8398V29.0142Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M3.099%2018.7008H0V25.5978L3.099%2026.1684L6.5436%2022.4742L3.099%2018.7014V18.7008Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M6.54421%2025.8828L3.09961%2026.1678V18.7008H6.54421V25.8828Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M8.86613%2010.0992L4.78613%2010.8768V26.5248L8.86613%2027.3804L12.6005%2018.7002L8.86613%2010.0986V10.0992Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M12.6%2026.9526L8.86621%2027.3804V10.0992L12.6%2010.527V26.9526Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M16.8213%2013.5798L11.1885%2014.1504V27.873L16.8213%2029.0142L22.8003%2021.261L16.8213%2013.5798Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M20.6187%2028.3722L16.8213%2029.0142V13.5798L20.6187%2013.8648V28.3722Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M23.9995%201.134L20.2021%202.3466V29.6562L23.9995%2030.4332L27.7969%2015.7836L23.9995%201.134Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M27.5156%2028.3722L31.1792%2029.0142L36.812%2018.7008L31.1792%208.4588L27.5156%209.0294V28.3722Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M35.3281%2026.9532L39.1327%2027.381L43.2127%2014.3646L39.1327%201.4196L35.3281%202.3466V26.9532Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M41.4551%2025.8828L44.8997%2026.1678L47.9987%2013.2948L44.8997%200L41.4551%200.8556V25.8828Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M24%201.134L27.7974%202.3466V29.6562L24%2030.4332V1.134ZM36.8118%209.6L31.179%208.4588V29.0142L36.8118%2027.873V9.6ZM43.2144%203.06L39.1344%201.4196V27.381L43.2144%2026.5248V3.06ZM48%201.5618L44.901%200V26.1684L48%2025.5978V1.5618Z%22%20fill%3D%22%23F58534%22%2F%3E%3C%2Fsvg%3E%0A)AWS Athena · Connected Data Mart · Published · one definition ![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google SheetsDaily 09:00 Refreshed on a schedule. No exports, no copy-paste. [Get Started Free](https://www.owox.com/app-signup) ## S01 · Step 1 ## Start from your AWS Athena data Pick the Athena database that holds the data your spreadsheets need. * Nothing to move or copy. ![](data:image/svg+xml;utf8,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%2048%2048%22%20fill%3D%22none%22%3E%3Cpath%20d%3D%22M48%2029.0142L24%2026.0256L0%2029.0142L24%2048L48%2029.0142Z%22%20fill%3D%22%23FCBF92%22%2F%3E%3Cpath%20d%3D%22M0%2029.0142L24%2036.2676V48L0%2035.8398V29.0142Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M48%2029.0142L24%2036.2676V48L48%2035.8398V29.0142Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M3.099%2018.7008H0V25.5978L3.099%2026.1684L6.5436%2022.4742L3.099%2018.7014V18.7008Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M6.54421%2025.8828L3.09961%2026.1678V18.7008H6.54421V25.8828Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M8.86613%2010.0992L4.78613%2010.8768V26.5248L8.86613%2027.3804L12.6005%2018.7002L8.86613%2010.0986V10.0992Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M12.6%2026.9526L8.86621%2027.3804V10.0992L12.6%2010.527V26.9526Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M16.8213%2013.5798L11.1885%2014.1504V27.873L16.8213%2029.0142L22.8003%2021.261L16.8213%2013.5798Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M20.6187%2028.3722L16.8213%2029.0142V13.5798L20.6187%2013.8648V28.3722Z%22%20fill%3D%22%23F58534%22%2F%3E%3Cpath%20d%3D%22M23.9995%201.134L20.2021%202.3466V29.6562L23.9995%2030.4332L27.7969%2015.7836L23.9995%201.134Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M27.5156%2028.3722L31.1792%2029.0142L36.812%2018.7008L31.1792%208.4588L27.5156%209.0294V28.3722Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M35.3281%2026.9532L39.1327%2027.381L43.2127%2014.3646L39.1327%201.4196L35.3281%202.3466V26.9532Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M41.4551%2025.8828L44.8997%2026.1678L47.9987%2013.2948L44.8997%200L41.4551%200.8556V25.8828Z%22%20fill%3D%22%239D5025%22%2F%3E%3Cpath%20d%3D%22M24%201.134L27.7974%202.3466V29.6562L24%2030.4332V1.134ZM36.8118%209.6L31.179%208.4588V29.0142L36.8118%2027.873V9.6ZM43.2144%203.06L39.1344%201.4196V27.381L43.2144%2026.5248V3.06ZM48%201.5618L44.901%200V26.1684L48%2025.5978V1.5618Z%22%20fill%3D%22%23F58534%22%2F%3E%3C%2Fsvg%3E%0A)AWS Athena · Your data warehouse · Database Unified Ad Spend · Connected data · Nothing to move or copy ## S02 · Step 2 ## Build a reporting library in AWS Athena Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the data model. * Business users browse reports, not tables. Data marts · Unified Ad SpendAI · SessionsAI Unified Ad Spend · Data model · platform\_roas · platform\_cpa Unified Ad Spend + Sessions Sessions · Joined by a shared key ## S03 · Step 3 ## Send AWS Athena data to Google Sheets Push a report from the OWOX UI, or pull it with the Sheets extension. Header notes explain every column. * Reports stay fresh, with no exports. OWOX · Run report · Scheduled Extension · Refresh ![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets · Notes in headers · costInUsd · clicks · impressions ## S04 · Step 4 ## Keep Google Sheets connected to the same data Ask in Claude, export to a sheet, share with the boss. * One source, every tool. Unified Ad Spend · One source ![](https://cdn.owox.com/www/portfolio-management-data-destination/claude/logo/2.svg/public)Claude · Ask in chat ![](https://cdn.owox.com/www/portfolio-management-data-destination/google-sheets/logo/1.svg/public)Google Sheets · Export to a sheet Your boss · Share the answer ## Related connectors [AWS Athena to API](/connectors/aws-athena-connector-to-api)[AWS Athena to ChatGPT](/connectors/aws-athena-connector-to-chatgpt)[AWS Athena to Claude](/connectors/aws-athena-connector-to-claude)[AWS Athena to Data Studio](/connectors/aws-athena-connector-to-data-studio)[AWS Athena to Microsoft Excel](/connectors/aws-athena-connector-to-microsoft-excel)[AWS Athena to Email](/connectors/aws-athena-insights-to-email)[AWS Athena to Google Chat](/connectors/aws-athena-insights-to-google-chat)[AWS Athena to Microsoft Teams](/connectors/aws-athena-insights-to-microsoft-teams)[AWS Athena to Slack](/connectors/aws-athena-insights-to-slack) · Show 6 more · Show fewer ## Recent updates * [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog/#compare-linkedin-ads-results-across-markets-spend-by-country-region-and-county-0430) * [0.43.0 · The Sheet link of a Google Sheets source opens the imported tab, not the first one](https://docs.owox.com/docs/changelog/#the-sheet-link-of-a-google-sheets-source-opens-the-imported-tab-not-the-first-one-0430) * [0.43.0 · Connect a Google Sheets plan with one Google sign-in](https://docs.owox.com/docs/changelog/#connect-a-google-sheets-plan-with-one-google-sign-in-0430) * [0.41.0 · Rotating a warehouse key is one change: Storages share reusable Credentials](https://docs.owox.com/docs/changelog/#rotating-a-warehouse-key-is-one-change-storages-share-reusable-credentials-0410) * [0.41.0 · Dates from Google Sheets arrive as dates, not text](https://docs.owox.com/docs/changelog/#dates-from-google-sheets-arrive-as-dates-not-text-0410) ## Why OWOX ## Why OWOX for AWS Athena and Google Sheets OWOX keeps AWS Athena for storage and puts governed Data Marts between it and Google Sheets, so every number has one definition. * **You own the data.** It stays in your S3 and Athena. OWOX queries it in place and keeps no copy. * **Defined once.** Analysts write the Data Mart in SQL once; every sheet that refreshes from it shows the same numbers. * **Traceable numbers.** Every figure in a sheet traces back to a Data Mart, not to a pasted export. [Book a call](/book-a-call) [Get Started Free](https://www.owox.com/app-signup) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Get Started Free](https://www.owox.com/app-signup) - [AWS Athena to API](https://www.owox.com/connectors/aws-athena-connector-to-api) — /connectors/aws-athena-connector-to-api.md - [AWS Athena to ChatGPT](https://www.owox.com/connectors/aws-athena-connector-to-chatgpt) — /connectors/aws-athena-connector-to-chatgpt.md - [AWS Athena to Claude](https://www.owox.com/connectors/aws-athena-connector-to-claude) — /connectors/aws-athena-connector-to-claude.md - [AWS Athena to Data Studio](https://www.owox.com/connectors/aws-athena-connector-to-data-studio) — /connectors/aws-athena-connector-to-data-studio.md - [AWS Athena to Microsoft Excel](https://www.owox.com/connectors/aws-athena-connector-to-microsoft-excel) — /connectors/aws-athena-connector-to-microsoft-excel.md - [AWS Athena to Email](https://www.owox.com/connectors/aws-athena-insights-to-email) — /connectors/aws-athena-insights-to-email.md - [AWS Athena to Google Chat](https://www.owox.com/connectors/aws-athena-insights-to-google-chat) — /connectors/aws-athena-insights-to-google-chat.md - [AWS Athena to Microsoft Teams](https://www.owox.com/connectors/aws-athena-insights-to-microsoft-teams) — /connectors/aws-athena-insights-to-microsoft-teams.md - [AWS Athena to Slack](https://www.owox.com/connectors/aws-athena-insights-to-slack) — /connectors/aws-athena-insights-to-slack.md - [0.43.0 · Compare LinkedIn Ads results across markets: spend by country, region, and county](https://docs.owox.com/docs/changelog) - [Book a call](https://www.owox.com/book-a-call) — /book-a-call.md