A scheduled R pipeline moving new Google Form responses into SQL Server for Power BI reporting.
Outcome: Kept feedback dashboards updated within minutes of submission without paid middleware.
Feedback collected in Google Forms needed to appear in Power BI without repeated manual exports or paid middleware.
I wrote an R pipeline that polled the linked Google Sheet at defined intervals, identified rows not yet ingested, and wrote them to SQL Server. Power BI could then query the stored data using DirectQuery.
Incremental updates let the script run repeatedly without duplicating previously ingested responses.
The dashboard could show feedback within minutes of submission. The workflow used the existing collection tools and added a small scheduled ingestion step.