Posting App for the Share&Nurture Facebook Media Sharing Team at Isha Foundation. The application is used for creating a posting schedule and is a platform for posting content related to Yoga on Facebook groups. Link to the spreadsheet: https://docs.google.com/spreadsheets/d/1aEwVAFVsE5zDzhRyN-DG1fK8AJcUzxy-IGMHVpcl6wY/edit?usp=sharing
- written in Google Apps Script (JavaScript) with Object-Oriented structure
- Custom functions in Google Sheets (Isha Tools tab, see examples below)
- API calls to the Bitly API for generating Bitly links (UrlFetchApp.fetch())
Once the primary volunteer puts the link to the Facebook post on his tab, it gets automatically shared to the secondary volunteer tab.
Creating short URLs bit.ly/3lWmCCW from long URLs https://www.youtube.com/watch?v=46DnVgHD_FM/?utm_source=Best%20series%20on%20Netflix&utm_medium=fb&utm_campaign=poleng&utm_content=Most%20watched%20series%20on%20Netflix The UTM parameters are saved and later used by a different application for bitly tracking.
Deleting a group once we decide we are not posting content in it anymore.
Changes the volunteer name throughout the spreadsheet and manages access to the spreadsheet for a new person.
Bitly API call
Rowfinder class
