Update Googlesheet Content using chatgpt

❓ Help and Questions
1

Hi All.

Kindly help me create this. willing to pay fort this scenario or bot. Following is the flow/sequence.

  • Open Google Sheets in Microsoft Edge:
  • Launch Microsoft Edge and navigate to the provided Google Sheets link.
  • Open a New Tab for ChatGPT:
  • Open a new tab in the same browser.
  • Navigate to https://chatgpt.com/.
  • Switch to Google Sheets (Tab1):
  • Activate the tab containing Google Sheets.
  • Copy the First Row:
  • Use automation commands to select and copy the first row content in the Google Sheet.
  • Switch to ChatGPT Tab (Tab2):
  • Make the ChatGPT tab active.
  • Paste and Modify the Prompt:
  • Paste the copied content into the input area.
  • Append “re-write the content in the inverted commas and provide output in the same format as the input provided” to the end of the input.
  • Submit the input to ChatGPT.
  • Capture ChatGPT Response:
  • Wait and capture the response from ChatGPT.
  • Return to Google Sheets (Tab1):
  • Switch back to the Google Sheets tab.
  • Update the first row with the response from ChatGPT.
  • Repeat for Subsequent Rows:
  • Move to the next row and repeat the process until all rows are processed.

Thankyou all

2

Hi @jarodprdp ,

We have a similar example here, this may help. If it doesn’t we also offer automation services and can do it for you.

Thanks,
Zek

1 Like
3

Hi Thankyou,

It indeed helped me Build some understanding about the workflow to begin with, and i was able to create something else useful Which i would love to setup on my raspberry Pi( any os, But on arm64, preferrable raspberry pi os) for automation. Does the agent setup works on (arm64 linux) for raspberry pi ?

Thankyou

4

Agent works only on Windows, Mac, IOS and Android at the moment. It doesn’t work on linux systems.

5

I don’t mean to sound greedy but It would definitely be amazing however if it also worked on Linux too. Especially those tiny devices that people use to setup automation very often.

6

Hi Jarod,

I can definitely help you automate that Google Sheets/ChatGPT workflow. I’ve built a few similar scenarios for clients before, so I’m pretty familiar with this kind of automation.

You can reach out to me on my email here

Colin

1 Like
7

Hi @jarodprdp ,
Currently Linux is not prioritized since we focus on more to the other subjects.

Linux is useful when you are working for headless solutions that uses regular automation frameworks like selenium since it is much cheaper to scale for scraping and collecting data. However, we are more like a desktop automaton and it is a different architecture and has some other benefits which Linux may not be the best use case.

8

Thanks for being involved @Colin :slight_smile: