A demonstration of how a react-native app can work with google sheets directly.
- Root directory is the client - uses expo
serverdirectory is the backend - uses node js and googleapis
- Clone the repo
- Rename
.env.exampleto.envin the server directory - Set environment variables accordingly there
- Start server by running
cd server,yarnand thenyarn run start - Start client by running
yarnand thenyarn run start
- Add, update, delete data from Google Sheet - Server
- Eject - expo
The server expects the reposnse from google sheet to have all the names in Col A and their entries next to them.
Something like this:
| Name (Row not actually in the sheet) | Amount1 | Amount2 |
|---|---|---|
| Luigi | 200 | |
| Ryu | 500 | -20.12 |
| Zen | -123.34 | 199 |
| Mario | 123 |