Google Sheets data to Openai for analysis

My goal is for open.ai to analyse a full spreadsheet of data from google search console, which is in google sheets. Then create a commentary on the performance of the data.

I currently have Google Sheets, Search Rows, Into Openai. Which pulls through the data, but it returns it line by line.

This won’t work when my rows are over 70,000+

I want this to run monthly, so its essentially a first round of monthly commentary created.

Can anyone advise the best way to manage this process?

Welcome to the Make community!

Perhaps you can try uploading your file to assistants for knowledge retrieval. There are some posts on this forum about this, do give it a search.

2 Likes