# 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

![](https://963067965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MIJW5nbmYRaSNWePAac%2Fuploads%2FjU5rQQ4VLbu4uo5FHb9p%2Fgs_1.png?alt=media\&token=783b8015-12f7-47b9-8ee8-7c0e8fed377e)

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

![](https://963067965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MIJW5nbmYRaSNWePAac%2Fuploads%2FxEbm5roH4l7tE1WbRZ0o%2Fgs_2.png?alt=media\&token=0c33c1d2-5e38-402b-ba8c-4b47a81cc750)

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

![](https://963067965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MIJW5nbmYRaSNWePAac%2Fuploads%2FZ9fcGSgb8bUersV8ZJ0P%2Fgs_3.png?alt=media\&token=deb81c38-a6d7-4df7-8bfd-563900b955c2)

4\. Select one or more tabs to import.

![](https://963067965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MIJW5nbmYRaSNWePAac%2Fuploads%2FK9gc4VKfc70Pd0NGi5y7%2Fgs_4.png?alt=media\&token=6060d948-c9ca-40d3-9242-def87f9b8160)

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.

![](https://963067965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MIJW5nbmYRaSNWePAac%2Fuploads%2FZ2rsiZQeIOYHl4RL50zd%2Fgs_5.png?alt=media\&token=751d8dea-e506-4225-9c07-e61fc853ede1)

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

![](https://963067965-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MIJW5nbmYRaSNWePAac%2Fuploads%2Fql1kMe9EXY778O6EaLN5%2Fgs_6.png?alt=media\&token=b5f7976b-fde6-4b72-bebc-711d0b52111e)