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

# 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>" %}