Google Sheets Automation
Budget: $15 – $25 USD
Authentication:
Store at user level - once a user is signed in, doesn’t need to sign in again.
Authenticate using our server’s backend authentication mechanism
Authentication credentials to be hosted in sidebar
Data sources and APIs
Each workbook should be created from a template. It will have
Cover page
One or more presentation tabs
Control sheet with details of APIs to be called and reference of source table destinations
One or more Data tables tabs
data table APIs to be called initially to populate metadata
A set of data table APIs to be called subsequently with dynamic queries (read from cells)
Data Update
Auto refresh of APIs at hourly or longer intervals (user option)
Refresh of APIs through user action (refresh button)
Handle pagination
Auto Archiving
Reports to be auto archived at end of the day
A folder structure to be created under root folder SilaeData for Year/Quarter/Month/Week
Archived reports to refresh only on user action and not automatically
Store at user level - once a user is signed in, doesn’t need to sign in again.
Authenticate using our server’s backend authentication mechanism
Authentication credentials to be hosted in sidebar
Data sources and APIs
Each workbook should be created from a template. It will have
Cover page
One or more presentation tabs
Control sheet with details of APIs to be called and reference of source table destinations
One or more Data tables tabs
data table APIs to be called initially to populate metadata
A set of data table APIs to be called subsequently with dynamic queries (read from cells)
Data Update
Auto refresh of APIs at hourly or longer intervals (user option)
Refresh of APIs through user action (refresh button)
Handle pagination
Auto Archiving
Reports to be auto archived at end of the day
A folder structure to be created under root folder SilaeData for Year/Quarter/Month/Week
Archived reports to refresh only on user action and not automatically