Use ChatGPT with Google Sheets to create a Blog

[Uncle Gizmo]

The article linked to is for intermediate to advanced users.

In this article, and YouTube Nibesh demonstrates how to create ChatGPT formulas in Google sheets with Google Apps Script.

One example demonstrates how to summarize a large block of text.

The other example demonstrates how to simplify English into easy-to-read English.

How to Integrate ChatGPT with Google Sheets Using Google Apps Script

Welcome to this tutorial on how to integrate ChatGPT with Google Spreadsheets using the GPT API and Google Apps Script. We will create two custom formulas, GPT_SUMMARY and GPT_SIMPLIFY. You can use GPT_SUMMARY to summarize a large passage or text int...

www.freecodecamp.org

There's also a video explanation here:-

@codingwithnibesh

 

[Jelari]

Спасибо за инструкции по использованию GPT, возможно, вы сможете подсказать, как именно я могу использовать GPT и какие преимущества это принесет.

 

[Gasman]

Why not watch the video?

 

[Itimor]

I agree, the video is very informative

 

[LogicLoom]

This thread is quite old, but it's worth mentioning (if people come looking for information like me) that GPT for sheets advanced so much in the last few months. I'm using it daily now for so many things from simple data clean up to creating entire tables with custom content. I love how intuitive and easy to use AI is becoming and it always saves me from a headache (or two) when I have to deal with sheets.

 

[Uncle Gizmo]

to creating entire tables with custom content

This comment is related to Microsoft Access...

Create a table in MS Access with ChatGPT

If I need a new table, imagine a customer table with the customer name and address telephone number, things like this.

I will discuss it with ChatGPT, agree on the fields required, then I asked chatGPT to write me a VBA function. I import it into my MS Access, run the VBA function and it creates the table for me!

I can then ask ChatGPT to build a set of sample data for the table and again write a script that fills this new table with the sample data!

Lazy OP's
I use this technique when trying to answer questions for OPs on access world forums who for some reason cannot provide sample data!

 

[kalabas]

Great tutorial
Been implementing it for months now and looking for better ways to utilize it