So, I stumbled on this gig recently. The client needed a clear-cut path worked out between the trio of all previously mentioned Google Tools. Considering all tools needed for the task were Google-based, integration was quite easy. There was zero need for connectors like Zapier nor scripting code for API intercoms. Essentially,
Google Forms - Collects Data
Google Sheets - Stores Collected Data
Looker Studio - Enables visualization and analysis of collected data.
Ive explored how those tools were connected to build out the desired workflow.
Getting Started with Google Forms
To get started, I created the following basic Google Form to facilitate data collection. Considering the client didn't specify the datatypes to be collected. I revolved the datatypes around sales. Since the solutions were definitely business oriented, seemed pretty apt to me.
https://docs.google.com/forms/d/e/1FAIpQLSc--Bkg1wP2-uw4pyeqQUNxD6VqHT3oEnUqyJ4T01Q8EfSfmw/viewform
So, when a sales rep fills out sales details in the provided Google form, the response gets stored automatically on the Google sheets.
Streamlining Data Storage with Google Sheets
Google Sheets is where the project gets tricky. Considering I have zero actual sales reps to fill out the data I needed, I resorted to Mockaroo to work up a mock dataset I could work with.
Here's my Mockaroo adjustments:
Here's the data set neatly outlined in my Google Sheets.
Top comments (0)