Workflow Automation Projects

These are present and past projects I’ve worked on that deals with workflow automation & optimization.


Boss Tracker

Project status: Completed, no longer maintained

Used Apps/Services

  • Discord
  • Google Sheets
  • Google Apps Scripts
  • Zapier

Description

This automation was made for a Discord server to monitor respawn times of bosses in a massively multiplayer online game from the time they were last killed.

Input comes from the players by posting the boss name, the place/map it was found, and its time of death on the designated Discord channel which a Zapier zap listens to.

Discord player input
A user of the Discord server inputs information about the latest boss killed.

The zap then forwards the information to a Google spreadsheet. The sheet uses a combination of formulas and app script to compute for the upcoming schedule of when the boss will spawn again then generate a message containing such information in a new row on another sheet.

Another zap that’s listening to the spreadsheet then detects that new row and publishes the message as an alert on a designated channel in the Discord server.

Zapier pushes alert to Discord channel
Zapier zap pushes alert message from the Google spreadsheet to a Discord channel

Project Links


Google Analytics Data on Geckoboard Custom Widgets via Google Sheets

Project status: Completed, no longer maintained

Used Apps/Services

  • Google Analytics
  • Geckoboard
  • Google Sheets
  • Google Apps Scripts

Description

//

Project Links


SERPs (Search Engine Results Pages) Competitor Scraper Tool

Project status: Completed, no longer maintained

Used Apps/Services

  • Microsoft Excel 2007-2010
  • SeoTools for Excel (Add-in)

Description

//

Project Links


SERPs Competition Analysis Tool

Project status: Completed, no longer maintained

Used Apps/Services

  • //

Description

//

Project Links


Keyword Feasibility Score Table

Project status: Incomplete, discontinued

Used Apps/Services

  • //

Description

//

Project Links


Google Analytics to Google Sheets – Data Tracking

Project status: Completed, no longer maintained

Used Apps/Services

  • //

Description

//

Project Links