Processing data from Google Sheets cell in GPT and back
Task: We need to process the prompt from cell F2 and output the result in cell A2
Tables:
What needs to be done?
In this table, there is a sheet called "Project Legend"
In this table, there are prompts in cell F2, and we need to process them based on the information from the "Project Legend" sheet
The information goes to GPT, which then processes our request from cell F2 based on the Legend, and writes the result in cell A2 in the table
Please suggest solutions
-
4 days30 USD
96 4 days30 USDGood afternoon. I can help write a script in Apps Script with a connection to chat GPT that will generate your prompt from a file and return the neural network's response to the desired cell.
-
1 day55 USD
1449 24 3 1 day55 USDHello, I am ready to quickly and efficiently complete the task. I suggest discussing the details in private messages.
-
1 day50 USD
431 1 0 1 day50 USDGood day!
Automation can be done on the Make platform, it can match data from cells for free and generate content, you will only need to pay for the OpenAI API, but it's tenths or even hundredths of a cent per request. The scenario can be set up so that it will publish to any database or social networks, not just tables.
The use of Make is universal. Write to me, I will guide you on everything regarding automation. I will create the scenario you are asking for in an hour.
-
5 days160 USD
1315 7 0 5 days160 USDGood day.
I am ready to take on your project.
I can build automation for this data using no-code/low-code tools.
Message me privately, we will discuss all the details and find a solution for you.
-
3 days55 USD
1311 63 1 3 days55 USDFeel free to reach out, we'll discuss, I'll do it.
I added GPT as an assistant in MS Excel, Google Sheets is even easier.
-
У Вас є аккаунт розробника з балансом на chatGPT ?
Кожен такий запит буде коштувати грошей.
-
Greetings Mark.
Already thought about this action.
Here's a solution:
Google Apps Script allows you to:
Read data from the first column.
Process the text (e.g., correct errors, translate, change style, etc.).
Write the processed text to the neighboring cell.
Repeat this for all rows.
The script is run manually or automatically (e.g. when changing a table).
Once the Script is created, you can integrate the script into Google Table.
Here are the advanced steps:
Do via OpenAI API (ChatGPT)
Google Apps Script can send requests to ChatGPT via API and get the result.
How it works:
The script reads text from a cell.
Sends it to the OpenAI API with the desired request (e.g., “rewrite in Dostoevsky style”).
Receives a response from ChatGPT.
Inserts it into the table.
Cons:
Needs an OpenAI API key (paid).
I was not able to solve this task because I needed to pay for the API-key. You may find it useful.
Translated with DeepL.com (free version)
-
Тот кто Вам делал автоматическую отправку постов в ТГ не может сделать ? И рекомендую Вам сменить API key, так как Вы засветили все токены и ID чатов и админа.
-
А при чем тут ТГ ? Речь шла про GPT + Excel -- там совершенно другой API
-
Current freelance projects in the category AI & Machine Learning
Consultation on creating an AI agent to accelerate the resolution of routine tasks - 60 minutes
16 USD
Consultation on creating an AI agent to speed up the resolution of routine tasks. I have created an agent for automatic contract filling - it's simple, but there are more complex tasks that I would also like to delegate to GPT agents, and there are several questions I would like… AI & Machine Learning ∙ 13 hours 13 minutes back ∙ 12 proposals |
Automatic posting of stories on InstagramGood day, I need help with setting up automatic posting of stories on Instagram. There are already stories in the Instagram archive that have been published, and they need to be reposted. AI & Machine Learning, Bot Development ∙ 1 day 22 hours back ∙ 24 proposals |
Creation of an AI assistant for communication with ClientsIt is necessary to create an AI assistant for communication with Clients. The chat window will be located on our website, followed by communication with the bot. Questions about products, settings, capabilities, etc. In cases where the information is unknown or the request can… AI & Machine Learning, AI Consulting ∙ 2 days 17 hours back ∙ 34 proposals |
I am looking for a video editor who creates AI videos.Creation of AI videos for dentists and other experts Objective: To create short vertical videos for Instagram Reels, Facebook Reels, TikTok, and YouTube Shorts that explain complex topics in simple language and hold the viewer's attention through a combination of AI animation… AI & Machine Learning ∙ 3 days 1 hour back ∙ 2 proposals |
I am looking for a mentor/teacher for ComfyUI for online learning (working through RunPod)
16 USD
Hello. I am looking for a practicing specialist and mentor who can help me master working with ComfyUI. The main feature of my request is that the work will be done entirely in the cloud, without downloading the program to a local computer. I plan to rent a graphics card through… AI & Machine Learning ∙ 3 days 11 hours back ∙ 1 proposal |