Process Data in a List in Google Sheets

How To
1

Hi,

Here’s what I am trying to accomplish…

I have a list of keywords and monthly volumes extracted from Google Keyword Planner pasted in a Google Sheet.

I want to use OpenAI GPT4 to review the list of keywords and deduplicate the list (remove near duplicates, plurals etc.).

And paste the final keyword list and monthly volume data in two columns on the same sheet.

Here’s what I have figured out so far:

Google Sheets (Get Range Values) => OpenAI (Create a Completion) => Google Sheets (???)

Can someone share how to go about completing the above?

image
image908×1380 116 KB

Thanks in advance!

2

You’ll need to use Google Sheets “Make an API Call” module to call the spreadsheets.batchUpdate endpoint to request for a “DeleteDuplicatesRequest”.

Removes rows within this range that contain values in the specified columns that are duplicates of values in any previous row. Rows with identical values but different letter cases, formatting, or formulas are considered to be duplicates.

Screenshot_2024-01-07_040142

You will get something that looks like this (you fill in the GridRange and DimensionRange JSON by following the documentation)

Screenshot_2024-01-07_040141
Screenshot_2024-01-07_040141683×665 43.2 KB

2 Likes
3

Sorry, I still understand how to solve this problem.

blueprint.json (16.3 KB)

I uploaded the blueprint.

Hope you are able to assist in configuring Sheets API and the final ouput.

Thanks!