Phoenix - Your AI AssistantBuilding 2 ChatGPT function to Google Sheets
- Posted:
- Proposals: 3
- Remote
- #4267437
- Awarded
have already sent a proposal. Description
Experience Level: Entry
ChatGPT function to Google Sheets, you can do this by integrating OpenAI's GPT API into Google Sheets via Google Apps Script
1. To write questions/summaries based on copy inputted in certain sheets cells
2. To course latest publicaiotns based on figure name using
- to use function getLatestPublications(authorName) {
var url = 'https://api.scholar.org/publications/search?author=' + encodeURIComponent(authorName);
var response = UrlFetchApp.fetch(url);
var json = JSON.parse(response.getContentText());
var publications = [];
// Extract the titles of the latest 4 publications
for (var i = 0; i < Math.min(json.publications.length, 4); i++) {
publications.push(json.publications[i].title);
}
return publications;
}
1. To write questions/summaries based on copy inputted in certain sheets cells
2. To course latest publicaiotns based on figure name using
- to use function getLatestPublications(authorName) {
var url = 'https://api.scholar.org/publications/search?author=' + encodeURIComponent(authorName);
var response = UrlFetchApp.fetch(url);
var json = JSON.parse(response.getContentText());
var publications = [];
// Extract the titles of the latest 4 publications
for (var i = 0; i < Math.min(json.publications.length, 4); i++) {
publications.push(json.publications[i].title);
}
return publications;
}
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.