Authenticate Google Sheets

Ensure that DataSyncs can properly access your Google Sheet

Click "Share", and ensure that "Anyone on the internet with the link can view"

You can simply copy the link from your browser and paste it directly into the DataSyncs configuration page."