![Google Sheets](https://images.ctfassets.net/wl4obrmf3nbz/57eNtT8682dkf2st5F7PTU/254a8eecaa36ea2e1757ab5d19402af4/google-sheets.png)
Google Sheets
Streamline Your Workflow: Integrate Google Sheets with Lemonado
How to add Google Sheet document to Lemonado
- Add Google Sheets from the Data View
- Authorize Lemonado to access your Google Sheets
- If you have multiple tabs, you can select the tab that you want to sync
- Verify that Lemonado have automatically identified your columns and column types
- Done!
Example video
![Google Sheets Video](http://images.ctfassets.net/wl4obrmf3nbz/6jjQcBBNlH4nQD7jiYZ7EW/cfa99caa7bdded6e4eca7ec4ea748535/google_sheets.webp)
How should my sheet be structured?
The sheet need to have a tabular structure with column headers on the first column:
![Google Sheet structure](http://images.ctfassets.net/wl4obrmf3nbz/2vAWunfDEKREkpPgoIksSY/59dc4a161955844e2a5c3f111dd9cba4/googlesheets_example_light.png)
How often until my sheet is refreshed?
Google Sheets are cached for 10 seconds to speed up the loading time.
Create a calculation widget with Google Sheets data
Learn how to create a calculation widget using your Google Sheets data