Gdisf Social Media Scheduler

Abstract

1. Introduction

export TWITTER_CKEY='your_twitter_consumer_key' export TWITTER_CSECRET='your_twitter_consumer_secret' export TWITTER_ATOKEN='your_twitter_app_token' export TWITTER_ASECRET='your_twitter_app_secret' export SPREADSHEET_ID='id_of_the_google_spreadsheet' export SPREADSHEET_CREDENTIALS='json_credentials_from_google_apps' export INTERVAL=3600

2. Objective

GDISF Social Media Scheduler

This project demonstrates how Python can be applied to a real-world Digital Marketing & SEO problem.

3. Key Features / Modules

• Reads the spreadhseet
• Gets information only from upcoming workshops
• Gets photos
• Randomly picks a message and a photo
• Posts message to Twitter every X seconds

4. Technology Stack

5. System Requirements

General requirements for this technology stack — check the README for exact versions.

• Python 3.8 or later
• pip / virtualenv for dependencies
• VS Code, PyCharm or Jupyter Notebook
• Git (to clone the repository)

6. Installation & Setup

git clone https://github.com/karlalopez/gdisf-social-media-scheduler.git
cd gdisf-social-media-scheduler

1. First, create a Heroku account: https://signup.heroku.com/
2. Create a new app on Heroku: New >> Create new app
3. Install the Heroku Toolbelt: https://toolbelt.heroku.com/
4. Login to Heroku on Terminal:
5. Add Heroku's remote git repo
6. Export the needed credentials as variables:
7. Define your time interval (to post) in seconds. Ex: 3600 for 1 hour.
8. To deploy, push the code via Git:

$ heroku login
Enter your Heroku credentials.
Email: your@email.com
Password:
Authentication successful.

$ heroku git:remote -a name_of_your_heroku_app

$ heroku config:set TWITTER_CKEY='your_twitter_consumer_key'

$ heroku config:set TWITTER_CSECRET='your_twitter_consumer_secret'

Full setup instructions are in the project README.

7. Future Enhancements

Suggested extensions you can add to make this your own project.

• Export reports to Google Sheets or PDF
• Schedule weekly automated reports
• Add competitor comparison

8. Viva / Review Questions

Common questions examiners ask for projects in this domain.

1. Which marketing or SEO problem does this tool solve?
2. Which data sources or APIs does it use (Search Console, Analytics, social platforms)?
3. Which metrics or KPIs does it report and how are they calculated?
4. How could the output help a business make decisions?
5. How would you schedule it to run automatically?

9. Source Code & License

This project is developed by karlalopez and published on GitHub under the Mozilla Public License 2.0. Please follow the license terms and credit the original author when you use or modify this code.