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?

Curran35278
May 15, 2024A: 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