SheetMagic: ChatGPT + Google Sheets Integration

Product details

Q: I want to extract the Kununu (similar to Glassdoor) score of a company.

But using the Visit-Function and then AI, i get an error that the token length is too much.

Can you support?

Use case and current idea:
1. Cell B1 =Visit(https://www.kununu.com/de/studyflix)
2. Cell B2 =ai("what is the kununu score of the company?", B1)

Gets:
Error: Unable to get a response from AI. Response: {"error":{"message":"This model's maximum context length is 4097 tokens. However, your messages resulted in 8847 tokens. Please reduce the length of the messages.","type":"invalid_request_error","param":"messages","code":"context_length_exceeded"}}

Already tried ailong, also no success, same error.

Can you support? What would be a workaround to get questions answered about the visited website?

0c5458688b8a4c458a115b2d213e0306PLUSJan 8, 2024
Founder Team
Curran35278

Curran35278

May 15, 2024

A: It's a token error so you could try a model with a larger token length, like =ai16k or =gpt432k

Essentially that error message is telling you that the current model you're using doesn't support how long your prompt is, so you need a model with a larger token context. Or you could use one of the other scraping functions that gives you a smaller output of the website.

Hope that helps!

Best,
Curran

Share
Helpful?
Log in to join the conversation