Android Flutter App: Google Sheets + Firebase Integration
Budget: $10 – $100 USD
Android Flutter App: Google Sheets + Firebase Integration
Task Description: Create a functional architecture to enable integration between Google Sheets and Firebase.
The data from Google Sheets should be parsed using the cloud functions to ensure that it aligns with the structure of the Firebase database.
Google Sheets is used as a Content Management System.
1. Cloud Functions for Data Transfer:
The application consists of multiple screens containing text, and the values of this text must be imported into the application database from Google Sheets using Firebase Cloud Functions.
2. Manual Data Fetch:
When we'd like to manually update the Firebase database after making changes to the spreadsheet, integrate a command, webhook or a button directly into the Google Sheets interface to trigger our cloud function to fetch the updated data and reflect it in Firebase.
3. Scheduled Data Transfer:
Set up a scheduled cloud function to run at your specified intervals, for instance, once a day (should be configured on ‘çfg’ sheet in the spreadsheet. This function will automatically read data from Google Sheets and update the Firebase database, ensuring that the mobile application always has access to the most recent data.
Additional information:
The table consists of several sheets:
"cfg" (configuration parameters for the application, e.g., update frequency).
"msg" (text blocks on the application screens).
"content" (content part of the application - for future iterations).
Outcome:
1. Upload the new version of the app to Google Play, and verify operability.
2. Before uploading to Google Play submit the APK for verification on our end.
Questions and/or suggestions welcome.
Task Description: Create a functional architecture to enable integration between Google Sheets and Firebase.
The data from Google Sheets should be parsed using the cloud functions to ensure that it aligns with the structure of the Firebase database.
Google Sheets is used as a Content Management System.
1. Cloud Functions for Data Transfer:
The application consists of multiple screens containing text, and the values of this text must be imported into the application database from Google Sheets using Firebase Cloud Functions.
2. Manual Data Fetch:
When we'd like to manually update the Firebase database after making changes to the spreadsheet, integrate a command, webhook or a button directly into the Google Sheets interface to trigger our cloud function to fetch the updated data and reflect it in Firebase.
3. Scheduled Data Transfer:
Set up a scheduled cloud function to run at your specified intervals, for instance, once a day (should be configured on ‘çfg’ sheet in the spreadsheet. This function will automatically read data from Google Sheets and update the Firebase database, ensuring that the mobile application always has access to the most recent data.
Additional information:
The table consists of several sheets:
"cfg" (configuration parameters for the application, e.g., update frequency).
"msg" (text blocks on the application screens).
"content" (content part of the application - for future iterations).
Outcome:
1. Upload the new version of the app to Google Play, and verify operability.
2. Before uploading to Google Play submit the APK for verification on our end.
Questions and/or suggestions welcome.