I have worked extensively in Google Apps Script and automation in Google sheets.
I also have experience in building sidebar add-ons.
I have also worked on
- API population of data into Google Sheets
- Alert Functionality to send reports/screenshots to slack channels and emails (time based)
- Alerts to email based on data changes (manual or via external API) in the Sheets with screenshots or reports on the cells updated/changed
- Custom Sidebars (to show wanted parameters of all the sheets in a sidebar addon)
- Google Authentications / authorisations --Publishing of workspace add-ons || standalone scripts
- Conversion of default script to Standard GCP project -- Increase of Quotas for different APIs enabled in the standard GCP Project
Examples of some projecta I have worked on recently
- Youtube Tracker: Automatic updation of Youtube channel info and corresponding videos
- Standalone Script: to automatically update Destination Sheet whenever any changes are made to Source
- Updation of Shopify Details from Shopify Store to Google Sheets
- Sending of email alerts and Sheet Screenshots from Google sheets based on time based or event based triggers or any custom conditional logic.