# Send every Form answer to a Google Sheet, with access only to the files you choose

> Baker connects to Google Drive so your Forms can save each answer as a new row in a Google Sheet. You can pick an existing sheet or ask Baker to create a new, empty one. Google only lets Baker use the files you choose in Google's file picker and the sheets Baker creates, never the rest of your Drive.

Source: https://withbaker.com/integrations/google-drive · Updated 2026-11-21

## What Baker does

- **Form answers in a sheet.** Every time someone completes a Form, Baker adds a row with the answers you mapped to the sheet's columns.
- **A new sheet in one step.** Ask Baker for a new sheet with the columns you need. It is created at once in your Drive and Baker gives you the link.
- **Leads from ad lead forms.** Leads from Meta, LinkedIn and Google Ads lead forms can be delivered to a sheet too, set up in a chat and started when you press Publish.
- **Deals for Account insights.** If your CRM is not HubSpot, an admin can ask Baker to create a sheet for your deals so LinkedIn's Account insights can count the pipeline your ads influenced.
- **A Drive folder as a media library.** Baker's team can connect a Drive folder of brand photos and videos so they fill your image and video libraries. Your originals are never touched.

## How it works

1. **Connect your Google account.** In Brain → Integrations, connect Google Drive with the Google account that owns or can edit your sheets.
2. **Choose or create a sheet.** In a chat, tell Baker which Form should go to a sheet. Pick an existing sheet or let Baker create a new one.
3. **Publish.** Press Publish so the Form goes live. From then on, every answer lands as a new row.

## What Baker reads and what it can change

| What | Baker | When | Why |
| --- | --- | --- | --- |
| Google Sheets you pick in Google's file picker | Reads | When you ask | To read the header row so each Form answer goes to the right column. |
| New rows in the sheet a Form sends to | Sends | All the time | Each completed Form adds one row, from the moment the Form is published. |
| A new, empty Google Sheet in your Drive | Changes | As soon as you connect | Created as soon as you ask in a chat, so the Form can point at it. It is listed in the chat as Already applied. |
| The folders you connect as media sources | Reads | All the time | Only when Baker's team connects a folder, to copy its images and videos into your libraries on a schedule. |

## What you need

- A Google account that can edit the sheets your Forms should fill.
- The admin or member role in Baker to connect it.

## What Baker's team switches on

- **Connecting a Google Drive folder as a source of images and videos for your libraries..** Reading a whole folder needs a wider Google permission, so Baker's team sets it up for now. Send a Request in Baker or write to support@withbaker.com.

## Questions

### Can Baker see everything in my Google Drive?

No. Baker asks Google only for access to the files you choose in Google's file picker and the files Baker creates. A folder for your media library is the one exception, and only Baker's team can connect one.

### Why is a new sheet created before I press Publish?

A Form needs to know its sheet before it can be published, so Baker creates the empty sheet as soon as you ask. Creating the sheet happens at once, it spends nothing, and nobody outside sees it. If you discard the chat, the empty sheet stays in your Drive.

### Baker can't read a document I shared with it. Why?

Baker can only open files chosen in Google's file picker or created by Baker. A link to any other file does not give Baker access to it.

### Is Google Sheets a separate connection?

No. Connecting Google Drive covers both Drive and Google Sheets.

## Guides

- [Connect Google Drive and Sheets to Baker](https://withbaker.com/help/integrations/google-drive.md)
- [Add a form that sends leads to your CRM](https://withbaker.com/help/add-a-form.md)
- [Connect an account to Baker](https://withbaker.com/help/connect-an-account.md)

## Still stuck?

Write to support@withbaker.com. A person answers within 24 hours. https://withbaker.com/help/contact
