Import ChatGPT table into Google sheets

Status: Open · Asked by MikeT on Aug 19, 2023 · 0 views

MikeT — Question · Aug 19, 2023

Your Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZjMDYzZjA0MzQ1MjZjNTUzMjUxMzQi_pc

Task History ID: IjU3NjEwNTZmMDYzZTA0MzM1MjY0NTUzYzUxMzU1MTYwNTQzNSI_3D_pc

I am using ChatGPT to create a summary of a conversation between two people that has been transcribed using Google Meet. Manually, I feed a chunk of the Google Doc transcription to ChatGPT and instruct ChatGPT to create a row each time the speaker changes with a summary of the conversation and keywords from the text. Typing in the prompt interactively with ChatGPT, the result returns a table that I then copy from ChatGPT into Google Sheets. The result is a table that looks like this:
[TABLE]
[TR]
[TD]Seq[/TD]
[TD]Date[/TD]
[TD]Speaker[/TD]
[TD]Summarized Key Point[/TD]
[TD]Keywords[/TD]
[TD]First Five Words[/TD]
[TD]Timestamp[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2023-08-17[/TD]
[TD]Sandra[/TD]
[TD]Criticism of Company regarding equipment purchase.[/TD]
[TD]Company, scam, equipment[/TD]
[TD]Sandra: When you buy a[/TD]
[TD]0:00:00[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2023-08-17[/TD]
[TD]Mike[/TD]
[TD]Agreement with Sandra's sentiment about Company.[/TD]
[TD][/TD]

[TD]Mike: Yep. Yeah, …[/TD]
[TD]0:00:00[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2023-08-17[/TD]
[TD]Mike[/TD]
[TD]Uses Office primarily for compatibility with friends who don't understand Google Docs.[/TD]
[TD]Office, PowerPoint, Word, video producer, Google Docs[/TD]
[TD]Mike: I have office.[/TD]
[TD]0:00:00[/TD]
[TD][/TD]

[TD][/TD]

[TD][/TD]
[/TR]
[/TABLE]

I want to use the ChatGPT API and Pabbly connect to automate this. I can easily provide the text to ChatGPT and get a table back. However, since it is multiple lines I need to use Line Itemizer to create the various like which I then want to transfer to Google Sheets. I have two questions:
1. What format should I ask ChatGPT to output the data in that will work with Line Itemizer. I tried CSV with the fields in double quotes (because some of my fields have commas in them) but Line Itemizer doesn't seem to like that when I turn the "Simple Response" switch off.
2. If I can get Line Itemizer to work, what feature of Google Sheets should I use to add the lines to the spreadsheet? Multiple rows, Append Rows, other?

Thanks so much for your help.

Mike

Arshil Ahmad — Reply · Aug 20, 2023

Hi @MikeT,

1. What format should I ask ChatGPT to output the data in that will work with Line Itemizer. I tried CSV with the fields in double quotes (because some of my fields have commas in them) but Line Itemizer doesn't seem to like that when I turn the "Simple Response" switch off.

The Line Itemizer tool accepts data in the form of a JSON array.

youtube.com/watch?v=GqaiQO_ekUQ

2. If I can get Line Itemizer to work, what feature of Google Sheets should I use to add the lines to the spreadsheet? Multiple rows, Append Rows, other?

Once you get comma-separated values, you can use the "Add Multiple Rows" action event in Google Sheets to save the data.

youtube.com/watch?v=rEB2UhYe3xk

Back to all forum threads · Log in to reply