How to tweak Natural Language API script in Google Sheets script editor to work with different columns of data.
All in google cloud platform
BigQuery Federated Queries via Google Sheets - Solving For 'Error while reading table: Could not convert value to date. Error: Invalid date'
Blog post looks at using Google Sheets as an external [federated] data source and how date format needs to be handled to query data. Solving For 'Error while reading table: Could not convert value to date. Error: Invalid date.