# Google Sheets

## Overview

Perform all your Drafter AI workflows right in Google Sheets for hundreds of entries. 

With this integration, you can do the following tasks without leaving Google Sheets:

* Analyze text for sentiment, topics, entities, and more
* Generate texts automatically from prompt templates, using multiple variables
* Generate content for hundreds of landing pages
* Classify hundreds of text entries into categories
* Perform multiple public search queries
* Provide examples (shots) at scale for AI to follow them

and many more.

Start scaling your AI ops right in your Google Sheets.

## How it works

{% embed url="<https://www.youtube.com/watch?v=w9JIrBCEw8k>" %}
Generating ads in Google Sheets
{% endembed %}

## Getting started

### 1. Install Extension

To install it, proceed to Google Workspace Marketplace:

{% embed url="<https://workspace.google.com/marketplace/app/drafter_ai/1018718532774>" %}
Reaching the extension
{% endembed %}

### 2. Get the API Key

{% hint style="warning" %}
&#x20;You should be signed up to Drafter AI first, to get your API key to the web application
{% endhint %}

{% @arcade/embed flowId="qMRmn4XQRxRRyjo6NMV3" url="<https://app.arcade.software/share/qMRmn4XQRxRRyjo6NMV3>" %}

{% hint style="warning" %}
You can generate and copy your API key **only once.**

If you forget or lose it, to use it again you'll need to re-generate it.

It's done to comply with the current security policies and protect your instance,
{% endhint %}

### 3. Give it a try

{% @arcade/embed flowId="7fFiO9nrrTk5ZRtGxdJo" url="<https://app.arcade.software/share/7fFiO9nrrTk5ZRtGxdJo>" %}


---

# Agent Instructions: 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:

```
GET https://docs.drafter.ai/direct-integrations/google-sheets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.