How to use Chat based AI with Google Docs or Sheets

Describe the problem/error/question - I want to process Google docs with AI chat models to refine or do some changes etc, then next stage the output is updated in the Google doc. How can I achieve it, I tried to lookup but got confused and couldn’t find a reliable answer. Same question goes with Google sheets, how can I process each row with AI based on existing columns and get AI reply to a new column in a column.

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.102.2
  • Database (default: SQLite): Postgress
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Linux Ubuntu

Dear MrTechbots,

There are various case for which you can use AI chat models with Google Doc and Google Sheet. Like in the following workflow I have used it to summarized the LinkedIn post and generate the topic of the LinkedIn post.

So, in this workflow following thing is happening.

Whenver this ai agent get trigger it will get all the LinkedIn post store inside Google sheet and with the help of AI chat model of Deep Seek it will generate two things for me.

  • Linkedin post topic
  • LinkedIn post summary

So that I can use the same information further, in the AI agent which is helping me write a better LinkedIn post. This is just a one use case, you can even build something like

Your own, personalized LinkedIn job applier agent, which customized your resume store in google doc as per the job requirement and apply for the job.

and so many thing.

If you are looking forward to any type of help in building any custome agent, please feel free to reach out, as I will love to help you any way possible.

Happy to help.

(if this answer become helpful please mark it as solution, because this will help me help other people too.)