> For the complete documentation index, see [llms.txt](https://docs.whaly.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.whaly.io/workflows/actions-catalog/google-sheets.md).

# Google Sheets

## Why using the Google Sheets action?

With the Google Sheets action anybody in your organization can send data directly to any sheets they have access to. 

This is useful to export data into Google Sheets for your business users that are very productive in Spreadsheets.

You can also export data in spreadsheet for it to be enhanced and then import it back within Whaly to build your reporting on enhanced data.

## What does it look like?

{% hint style="info" %}
This action is only compatible with **Questions**.
{% endhint %}

This action will **replace** a target sheet to a spreadsheet. If the target spreadsheet/sheet doesn't exist, they will be created.

## Configuring Google Sheet action

As an admin all you need to do is install the Google Sheet action in your organization. 

Your users will then have to authenticate with their Google Account in order to select where and which spreadsheets they want to create.

Users have the capability to create a new Spreadsheet or use an existing Spreadsheet to populate data into. 

This action will create a sheet with the same name as the file name with raw data in it. 

It will not erase other sheets in the destination spreadsheet. Therefore, it is safe to add other sheets into the destination spreadsheet if you want to run formulas on top of your exported data.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.whaly.io/workflows/actions-catalog/google-sheets.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.