I have a Sheet with data coming from a G-Form response. Using the Sheets' data connector I was able to make a connection to a BigQuery Table, but the Sheets data is not importing, and am unable to figure out why.
Sheets Data from Forms
TimeStamp | Email Address | Check box if info provided
10/02/2021 10:28:32 | jondoe@gmail.com | Name, Address, City
10/02/2021 12:32:44 | jaxdoe@gmail.com | Name, Address, City, Zip
10/03/2021 01:22:11 | jandoe@gmail.com | Name
BigQuery Table Fields and Schema
Field name | Type | Mode
Timestamp | DATETIME | NULLABLE
Email_Address | STRING(255)| NULLABLE
Response | STRING | NULLABLE
Data Preview after refreshing
