When a row is added to Google Sheets, summarize the content with ChatGPT and create a GitHub issue
When a row is added to Google Sheets, summarize the content with ChatGPT and create a GitHub issue
Launch this workflow to connect
ChatGPT &
GitHub
!
■Overview
When using GitHub for development projects, manually creating Issues based on various sources of information can be time-consuming.
This workflow automates the process of having ChatGPT automatically summarize the contents of a newly added row in Google Sheets and register it as an Issue in GitHub. By integrating ChatGPT with GitHub, you can reduce the time required to register tasks and keep your projects moving smoothly.
This workflow automates the process of having ChatGPT automatically summarize the contents of a newly added row in Google Sheets and register it as an Issue in GitHub. By integrating ChatGPT with GitHub, you can reduce the time required to register tasks and keep your projects moving smoothly.
■Who Should Use This Template
- Developers and project managers who manually create Issues in GitHub and want to streamline task registration
- Anyone who uses ChatGPT to summarize text and wants to automate the entire process, including registering the result in GitHub
- Anyone who manages tasks or bug reports in Google Sheets and wants to improve collaboration with their development team
■Benefits of Using This Template
- From adding information to Google Sheets to summarizing it with ChatGPT and registering an Issue in GitHub, the entire process runs automatically, reducing the time spent on manual work.
- Prevent human errors such as manual transcription mistakes and missing details in summaries. Standardizing Issue content also helps ensure accurate task management.
■Flowbot Steps
- First, connect Google Sheets, ChatGPT, and GitHub to Yoom.
- Next, select Google Sheets as the trigger, set the “When a row is added” action, and specify the sheet to monitor.
- Then, set up ChatGPT’s “Generate text” action as an operation and instruct it to summarize the Issue content based on the information in the added row.
- Finally, set up GitHub’s “Create an Issue” action as an operation to automatically create an Issue containing the text generated by ChatGPT.
※ “Trigger”: An action that starts the flow. “Operation”: An action that processes information within the flow after the trigger starts.
■Customization Options
- In the Google Sheets trigger settings, specify the spreadsheet, sheet, and table range from which to retrieve information.
- For the ChatGPT operation, customize the prompt (instructions) used to generate text and insert information retrieved from the spreadsheet as variables.
- For the GitHub action that creates an Issue, you can set fixed text or information retrieved in previous steps as variables for fields such as the repository, title, and body.
■Notes
- Connect each of Google Sheets, ChatGPT, and GitHub to Yoom.
- You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes. Please note that the shortest available interval varies by plan.
- To run ChatGPT (OpenAI) actions, you need a paid OpenAI API plan. (You must be able to make payments when the API is used.) For details, see the “OpenAI pricing page”.
- OpenAI charges for using the ChatGPT API based on the number of tokens used during API communication. Please note that an error will occur if you are unable to make payments when using the API.
- For important information about using Google Sheets as an app trigger, see “Important Notes on the Google Sheets Trigger for App Triggers”.
Check Out Similar Templates!
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
# Translated Text
After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
Based on the information from Jotform, draft a contract using ChatGPT and add it to Google Docs.
This is a business workflow that automatically drafts contracts using ChatGPT based on Jotform data and adds them to Google Docs. It reduces effort and errors, streamlining the contract creation process.
See more
About the Apps
ChatGPT
Related apps
Templates using
ChatGPT
Create a reply to the received email using ChatGPT and notify the specified Slack channel.
The minutes added to the database will be summarized using ChatGPT, and a notification will be sent to the specified Slack channel.
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
# Translated Text After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
Templates using
GitHub
Automatically add users to a specified GitHub repository using information from the Yoom database. Create and utilize a database in Yoom to manage employee information, among other things.
Automatically add new or updated GitHub issues to a Google Spreadsheet.
This flow adds an issue created on GitHub to Trello. By utilizing this flow, you can eliminate manual input errors. Additionally, by saving the time spent on manual tasks and allocating it to other work, you can resolve tasks quickly and improve productivity.
About the apps you use
ChatGPT
At Yoom, it is possible to automate various tasks by integrating with the ChatGPT API without any coding. For example, you can enable direct conversations with ChatGPT from chat tools like Slack or Chatwork, and easily integrate ChatGPT with other SaaS platforms without coding. ChatGPT can be utilized for various purposes such as summarizing meeting minutes, extracting text from email content, and creating product descriptions.
see detailsTemplates
Create a reply to the received email using ChatGPT and notify the specified Slack channel.
Create a reply draft for received emails using ChatGPT and notify on Slack.
The minutes added to the database will be summarized using ChatGPT, and a notification will be sent to the specified Slack channel.
Add the minutes added to the database to ChatGPT, summarize them, and notify on Slack.
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
# Translated Text After a meeting on Google Meet, ChatGPT automatically creates the minutes, translates them into multiple languages using DeepL, and shares them via email. This workflow eliminates the hassle of creating minutes and handling multiple languages, thereby improving team communication efficiency.
After a Google Meet meeting, create minutes using ChatGPT, translate them into multiple languages with DeepL, and share via email.
GitHub
Yoom allows you to utilize GitHub's API without any coding. You can automatically create new issues or add users to a repository using GitHub's API. Additionally, it is possible to synchronize GitHub issue information with Yoom's database.
see detailsTemplates
Automatically add users to a specified GitHub repository using information from the Yoom database. Create and utilize a database in Yoom to manage employee information, among other things.
Add a user from the Yoom database to a GitHub repository
Automatically add new or updated GitHub issues to a Google Spreadsheet.
Add new or updated GitHub issues to a Google Spreadsheet.
This flow adds an issue created on GitHub to Trello. By utilizing this flow, you can eliminate manual input errors. Additionally, by saving the time spent on manual tasks and allocating it to other work, you can resolve tasks quickly and improve productivity.
Add to Trello when an issue is created on GitHub.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Message Is Created in a Thread
When an Issue Is Created
When an Issue Is Created or Updated
When a Pull Request Is Created
When a Pull Request Is Created or Updated
When a Comment Is Created on an Issue or Pull Request
When an Issue Is Closed (Webhook Trigger)
When an Issue Is Opened (Webhook Trigger)
When a Webhook Is Received (Webhook Trigger)
When an Issue Is Opened (Webhook Trigger)
Flowbot operations
Generate Text
Generate Text (with Image)
Generate Text (Advanced)
Generate Text (Web Search)
Generate Text from Image URL
Convert Text to Audio File
Retrieve Model List
Create Thread
Add Message to Thread
Convert Audio File to Text (File Upload)
Create Issue
Add User to Repository
Get a List of Issues
Get Issue
Add Comment to Issue or Pull Request
Update Issue
Search Issues and Pull Requests
Search Users
Flowbot triggers
When a Message Is Created in a Thread
Flowbot operations
Generate TextGenerate Text (with Image)Generate Text (Advanced)Generate Text (Web Search)Generate Text from Image URLConvert Text to Audio FileRetrieve Model ListCreate ThreadAdd Message to ThreadConvert Audio File to Text (File Upload)
Flowbot triggers
When an Issue Is CreatedWhen an Issue Is Created or UpdatedWhen a Pull Request Is CreatedWhen a Pull Request Is Created or UpdatedWhen a Comment Is Created on an Issue or Pull RequestWhen an Issue Is Closed (Webhook Trigger)When an Issue Is Opened (Webhook Trigger)When a Webhook Is Received (Webhook Trigger)When an Issue Is Opened (Webhook Trigger)
Flowbot operations
Create IssueAdd User to RepositoryGet a List of IssuesGet IssueAdd Comment to Issue or Pull RequestUpdate IssueSearch Issues and Pull RequestsSearch UsersCreate Pull RequestGet Pull RequestUpdate Pull RequestRemove User from RepositorySearch IssuesSearch Pull RequestsList CommitsCreate Release NotesRetrieve Project Custom FieldsGet ProjectsList Pull Request FilesMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
