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

# Google Sheets

If you have a simple application that doesn’t require complex back end development, you can use a Google spreadsheet to store your data. You can easily read and record data to the spreadsheet directly from the app or through a browser, and each change is immediately reflected in your app.

1. In the Database inspector, click Create, and select Google Sheets

![](/files/wlUqAitMwMDzMXro66Hw)

2\. Copy your spreadsheet’s URL and click ‘Download’

![](/files/yrpK7RrYHJJLKXiQqAoh)

3\. If this is your first time doing this, you will need to log in and allow Flipabit to make changes to your tables.

![](/files/ckT7hzXLL5APWg0boCm5)

4\. Select one or more tabs to import.

![](/files/y8ZfeysSPdaq2TUjHZ2j)

5\. Specify a column name with an identifier. An identifier is a unique row value. Numeric identifiers are the easiest option. The identifier is required for making changes or deleting rows. When adding a new row, Flipabit automatically calculates the identifier based on the auto increment.

![](/files/aLjeNlWZWoPerpHC8GaR)

6\. To verify the imported data, go into the Database inspector, select the table, and click ‘Edit Data’.

![](/files/9OpZEpK7Ad3te2bWEdqE)