After the user completes their daily Google Form, their inputted data is automatically transferred to a Google Sheets file in real-time. However, we need to find a way to extract this data, so it can be inputted into our ETL pipeline. This can be done via the Google Sheets API, which requires use of Google Cloud Platform to establish API keys and associated tools
Required Files
N/A
User Story
As an engineer, I need to research how to use the Google Sheets API, so that I can perform a GET request to extract data to put into the pipeline
Description
After the user completes their daily Google Form, their inputted data is automatically transferred to a Google Sheets file in real-time. However, we need to find a way to extract this data, so it can be inputted into our ETL pipeline. This can be done via the Google Sheets API, which requires use of Google Cloud Platform to establish API keys and associated tools
Required Files
N/A
User Story
As an engineer, I need to research how to use the Google Sheets API, so that I can perform a
GETrequest to extract data to put into the pipeline