Bird Feeder for Google Sheets
An add-on for Google Sheets which allows the user to schedule, save, and automate posting to Twitter.
2015
3 years
ArchivedOpen SourceTeam of 2
No images exist
A Google Sheets add-on that connected to Twitter using the V1 API to automatically schedule and post to Twitter, coordinated with a presentation schedule. One of the first projects I built and deployed end-to-end, learning the full lifecycle of creating an add-on. Implemented OAuth authentication for the Twitter API, scheduled post queuing, and automated the coordination between spreadsheet data and social media posts. The project taught me the fundamentals of working with third-party APIs, OAuth, and scheduling systems as a beginner developer.
Technologies Used
language
JavaScript
framework
Google Apps ScriptTwitter API
authentication
OAuth
platform
Google Workspace
tool
Automation
Challenges
Implementing OAuth authentication for Twitter API, managing scheduled post queuing, and coordinating spreadsheet data with social media posts. Working within Google Apps Script constraints and the limitations of Twitter API V1.
Key Learnings
Full project lifecycle from initial setup to deployment and long-term maintenance. OAuth authentication patterns. Scheduling and automation. Google Apps Script for Google Workspace add-ons. Working with third-party APIs. Twitter API V1 integration.
