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 image exists for this project

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.

Project Details

Difficulty
beginner
Team Size
2
Duration
3 years

Related Projects

Back to all projects