Productivity log: track my assigned bugs in a spreadsheet
Start today
Popular GitHub and Google Sheets workflows and automations
Useful GitHub and Google Sheets integrations
Triggers (If this)
Any new notification from a repositoryThis Trigger fires every time you receive a new notification from a specific repository on Github.
New spreadsheet added to folderThis trigger fires when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.- Any new repository eventThis trigger fires every time a new event occurs in a repository.
- New worksheet in spreadsheetThis trigger fires when a new worksheet is added to a spreadsheet you specify.
- Any new releaseThis Trigger fires every time a repo release a new version on Github.
- New row added to spreadsheetThis trigger fires when a new row is added to a spreadsheet you specify.
- Any new commitThis Trigger fires every time a new commit in a repo is created on Github.
- Cell updated in spreadsheetThis trigger fires when a particular cell is updated within the spreadsheet you specify.
- Any new notificationThis trigger fires every time you receive a new notification on Github.
- Any new GistThis Trigger fires every time you create a new Gist on Github.
- Any new issueThis Trigger fires every time any new issue is opened in a repository you own or collaborate on.
- Any new closed issueThis Trigger fires every time any issue is closed in a repository you own or collaborate on.
- New issue assigned to youThis Trigger fires every time a new issue is assigned to you.
- New repository by a specific username or organizationThis Trigger fires every time a new repository is created by the username or organization you specify.
- New pull request for a specific repositoryThis Trigger fires every time a new pull request is opened for a repository you specify.
Queries (With)
- History of pull requests for a specific repositoryThis query returns a list of every time a new pull request is opened for a repository you specify.
- Current values of a rowThis query returns the current values in a given row. Values from columns A-Z are available as ingredients.
- History of issues assigned to youThis query returns a list of every time a new issue is assigned to you.
- Current value of a cellThis query returns the current value of a single cell in your spreadsheet.
- History of issuesThis query returns a list of every time any new issue is opened in a repository you own or collaborate on.
- History of rows added to spreadsheetThis query returns a list of when a new row is added to a spreadsheet you specify.
- History of repositories by a specific username or organizationThis query returns a list of every time a new repository is created by the username or organization you specify.
- History of when Cell was updated in spreadsheetThis query returns a list of when a particular cell was updated within the spreadsheet you specify.
- History of closed issuesThis query returns a list of every time any issue is closed in a repository you own or collaborate on.
- History of spreadsheets added to folderThis query returns a list of when a new spreadsheet is added to a Google Drive folder you specify. Note: only works for spreadsheets created after the Applet turned on.
- Lists users that have starred the repositoryThis query returns a list of users that have starred the repository.
- History of worksheets in spreadsheetThis query returns a list of when a new worksheet is added to a spreadsheet you specify.
- List watched reposThis query returns a list of repositories watched by the current user.
- List starred reposThis query returns a list of repositories starred by the current user.
- List starred GistsThis query returns a list of Gists starred by the current user.
- List Gists.This query returns a list of Gists owned by the current user.
Actions (Then that)
- Create new GistThis Action will create a Gist for you.
- Add row to spreadsheetThis action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
- Create an issue/pull request commentThis Action will comment in a specific issue or pull request on Github.
- Update cell in spreadsheetThis action will update a single cell in the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created if the file doesn't exist.
- Create an issueThis Action will create a new issue for the repository you specify.
GitHub and Google Sheets resources
9 Best Calendly Integrations for Small Businesses
This blog by IFTTT provides helpful Calendly integrations to help small businesses reach their goals.
Slack vs Discord - Best Chat App
Slack and Discord are the worlds most popular Chat apps. Click to learn which chat app to choose, Slack vs Discord.
IFTTT helps all your apps and devices work better together