Hi Abdullah,
Thanks so much for the fast response. Yes I am using the Pro Version and have two months of support remaining.
The drop down fields that remain empty can be seen here: https://imgur.com/qyXebWO
I have just tried to re-auth with Google but still seeing the same issue. The permissions settings should be fine because I am able to connect the sheet to the same form but just on a different page.
Thanks again for the ongoing help.
Cheers
Matt