Connected but not populating

Are you using Sheet on some Google Apps organization account?
Try to google “sheets api the caller does not have permission”.
For example, it finds this: https://www.roelpeters.be/solved-the-caller-does-not-have-permission-using-the-api-with-a-private-google-spreadsheet/

Thanks for heading me in the right direction! I have a business Google Apps organization account and connected that one, but I hadn’t shared the sheet to that accoun. Now it works like a charm!

All fields populate except the Phone No. Field. It shows #Error! – Formula parse error

Please help

Can you please post the full error here?