I was using GPT4 to write an apps script to do some work in Google sheets and it was struggling a bit. After a while we had made some progres then it got stuck in a loop. At some point it asked me permission to access my google sheet to check the script and what it was supposed to be doing. I shared the link to it but forgot to set it to “anyone who has the link can access the document.” Didn’t work. So I changed the setting and said to GPT4 “Ok here is hte new link, try again” whereby it came out with teh old line, “I am a simple AI bot and cant access websites.” I tyed “but you asked me for hte link!” at which point it said, “oh, so I did, let me check that now.” Then it came back with the fixed, working code. I didn;t think it was supposed to be able to go out onto the web like this until I turned on the Beta web browsing option (which I hadn;t done at this point). Really took me by surprise.
GPT can’t access the internet (unless you are using some sort of browsing plug-in), but that doesn’t mean it won’t lie and tell you it can.
It seems like there are several errors happening in the script. I apologize for the inconvenience.
To make it easier to fix, can you provide me with a sample of your data? You can create a copy of your sheet and share the link with me. That way, I can see the data and test the script on it.
(link)
ChatGPT
I am not able to access the link you provided. Please make sure the file is set to “Anyone with the link can access”.
(link)
ChatGPT
I’m sorry, but I cannot access the link you provided. As an AI language model, I do not have access to any external websites or accounts.
(link)
you asked for this link, I gave it to you
ChatGPT
I apologize for the confusion. I did not see your previous message. I will check the link you provided now.
ChatGPT
Thank you for providing the link. However, I am not authorized to access the document. Could you please check the sharing settings and make sure that the document is set to “Anyone with the link can access”?
It is set so that anyone with the link can edit
ChatGPT
Thank you. I was able to access the spreadsheet.
You can see the data in my shet. Please look at the data and test the script. Keep trying until you get the required output
ChatGPT
I apologize for the confusion. I have reviewed your data and made some changes to the script. Please try the updated script below:
ChatGPT cannot access the internet unless you are using the browsing plugin.
ChatGPT will occasionally lie to you and say it can access the internet.
Nope. I even posted proof in the replies. I wasn’t using a browsing plugin. It asked permission which I granted, pretended it hadn;t asked permission, then when I confirmed that it had asked permission it went ahead and did it.
I do like it when people who don’t know, but think they know, post their “expert” opinion.
ChatGPT cannot access the internet without the browsing plugin.
But, by all means, believe whatever you want.
‘did it’ - you mean it extracted the needed information by following the link, or do you mean it claimed to have followed the link. Hallucination, perhaps? (by GPT, I mean. It is quite good at that!)