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

# Google Sheets

## Getting Started

You can use Brewer's Friend [device forwarder](/profile/device-settings.md#forwarders) to send data to the Tilt Google Doc.

Official Tilt Google instructions, <https://tilthydrometer.com/blogs/news/easiest-way-yet-to-post-your-tilt-to-google-sheets>

1. **Google Spreadsheet** File ->  Make a Copy
   1. [https://docs.google.com/spreadsheets/d/1ut1wClRrowkYRYm6yQAVuc\_Q568stncawv1EuYez2g](https://docs.google.com/spreadsheets/d/1ut1wClRrowkYRYm6yQAVuc_Q568stncawv1EuYez2go/)
2. **Google Spreadsheet** Tools -> Script editor
3. **Script editor** Publish -> Deploy as a web app
4. **Google Spreadsheet** Tilt -> View Cloud URL (copy)
5. **Google Spreadsheet** File -> Make a Copy
   1. <https://docs.google.com/spreadsheets/d/155bcmMCWD6r9tbdTx01oEMms-86LjFeqndmWsu2RgJY>
   2. Paste the URL and document ID into the first copy

![](https://2223943643-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LY2qaPiuzv-wxqDpCst%2F-LZAoUEbxIWkePJOyDz-%2F-LZAozwUO6rf14-IEydD%2FScreenshot%202019-02-20%2009.48.16.png?alt=media\&token=f07845ee-bbeb-4339-8d7b-2938d1a67e12)

5\. **Brewer's Friend** Device Settings -> Add Forwarder (paste and save)

![](https://2223943643-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LY2qaPiuzv-wxqDpCst%2F-MOYa7InwkNP9d_7zecd%2F-MOYbf2SRU7z-mDM6o9t%2Ftilt-google-sheets.png?alt=media\&token=1ff30c55-dc5a-4f0c-9f8d-c9394c57ff28)