# Google Sheets Add-on: Extract Data Into Your Spreadsheet > Install the ImageToTable.ai add-on from the Google Workspace Marketplace, connect it to your existing account with Google sign-in or an API Key, and upload, process, and write extracted rows straight into the spreadsheet you have open — spending the same credits as the web app. The **ImageToTable.ai add-on for Google Sheets** puts the extraction tool in a sidebar next to your spreadsheet. You upload documents, process them, and write the extracted rows into the sheet you are working on — using the same account, [templates](/docs/reference/glossary#template), and [credits](/docs/reference/glossary#credits) as the website. ## Install the add-on Install it from the Google Workspace Marketplace: [ImageToTable.ai — Extract Data from Image](https://workspace.google.com/marketplace/app/imagetotableai_%E2%80%94_extract_data_from_image/758062068256?flow_type=2) Once it is installed, open any Google Sheet and go to **Extensions → ImageToTable.ai → Open**. The sidebar appears on the right of the spreadsheet; open it again the same way whenever you need it. ## Connect your account The add-on uses your existing ImageToTable.ai account — there is no separate account to create and nothing extra to subscribe to. The **Account** section at the top of the sidebar offers two ways to connect it: - **Sign in with Google.** Click **Sign in with Google** and approve the request. If that Google account is already linked to an ImageToTable.ai account, the sidebar opens it; if it is not, an account is created for it. - **Paste an API Key.** Type or paste the key into the **Paste API Key** box and click **Save**. The box tells you where to find it: the **API Key** section of your profile page on the website. The API Key is what links the sidebar to your account, so treat it like a password — anyone who has it can act as your account. To get one, or to replace one you no longer want to use, see [API Key management](/docs/guides/api-key-management). When you are connected, the Account section shows your username, your plan, and your **Balance** in credits. **Switch Account** connects a different account by API Key, and **Sign out** disconnects the sidebar without affecting anything in the spreadsheet. Because it is the same account, the sidebar shares everything with the web app: - The **Files** list shows the batches in your account, including ones uploaded or processed on the website. - The **Data Columns** section works with the templates you already saved on the website. - Processing spends the same credit balance shown on your profile. ## What you can do from the sidebar ### Upload documents In the **Your Uploads** section, use the **Upload** button in the **Files** tab to add files from your computer. Images, PDFs, Word documents (`.docx`), and plain text files (`.txt`) are accepted, and you can select several at once. Adding a PDF opens a **Select PDF Pages** dialog first, so you choose which pages to send rather than having to take the whole document. See [Uploading Documents](/docs/guides/uploading-documents) for what each file type does when it arrives. ### Choose what to extract The **Data Columns** section works like the one on the dashboard. Type a column name into the box (it suggests *Column name, e.g. Invoice Number*) and click **Add**; **New**, **Switch**, and **Settings** create, choose, and configure templates. Any template saved on the website is available here, so you can set your columns up once and use them from either place — see [Templates & Columns](/docs/concepts/templates-and-columns). If you start processing a batch that has no columns defined and more than one file, the sidebar can propose an **AI-Suggested Columns** list before it runs. ### Process a batch Each batch in the Files list has a play control that starts processing it. The sidebar checks your available credits first; if there are not enough for every file, it shows an **Insufficient Credits** dialog offering **Get More Credits** or processing the files the balance covers. A batch that has already been processed can be run again, and the sidebar asks whether to resubmit only the failed and unprocessed files or reprocess everything. ### Write results into the sheet **Insert** writes the extracted rows into the sheet that is currently open. You can insert a single file's result, a whole batch, or several batches at once — results that share the same columns are written under one header, whatever batch they came from. Every inserted row carries its source **File Name** and **Batch**, so rows stay traceable after they land in the sheet. If the columns of an insert match the last insert into that sheet, the rows are appended underneath the existing header. If the column set is different, a new header row is added above the new rows instead of mixing them into the old table. Before inserting, you can open a preview that shows the extracted table alongside the original document and lets you page through the files in the batch. The sidebar processes files in To Table mode, so the result it writes is the extracted table; a batch with no table result has nothing to insert. For a document you want back as editable Word output rather than a table, use the web app's To Word mode and [Export](/docs/guides/export). ## How credits work The add-on has no separate quota of its own. Processing from the sidebar is charged against the same [credits](/docs/reference/glossary#credits) as the web app, at the same rate: one charge per processed file, set by your account's [Model Tier](/docs/concepts/model-tier). Because every page of a PDF, Word, or text file counts as its own file, a multi-page document uses several credits. The Account section always shows your current balance, and **Get more** takes you to the plans page. Using the add-on does not earn or consume a different kind of credit — a balance spent here is the same balance you would spend on the website. The per-plan details are on [Plans & Credits](/docs/guides/plans-and-points). ## Common questions ### Do I need a separate account or subscription for the add-on? No. The add-on connects to the account you already have, and it has no separate quota. Any plan you hold applies here too. ### Will I see the same files and templates as on the website? Yes. The Files list, the templates in Data Columns, and the credit balance all come from your account, so a batch uploaded on the website can be processed here and the results inserted into your sheet. ### Which sheet do the results go into? The one that is active when you insert — the tab you have selected in the spreadsheet the sidebar is attached to. If you are inserting a new column set, a header row is added above the data. ### What happens if I run out of credits? Processing does not start. The sidebar shows how many credits you have and how many the batch needs, and lets you get more or process just the files your balance covers. See [Plans & Credits](/docs/guides/plans-and-points). --- Source: https://imagetotable.ai/docs/guides/google-sheets-add-on