CIFL Office Hours 6/1

This is a recurring office hours session every Thursday, where we chat all things Google Sheets + automation.

This week's theme was Data Studio - using it to build dashboards and automate your reporting.

For answers to this week's questions, check out this Google Sheet:

Questions we covered this week:

1. How does data from a Google Form need to be formatted to push to Data Studio?
2. Is it possible to connect FB Ads, Infusionsoft, Xero and other custom datasets using Data Studio, Sheets and Apps Script for free
(without using Supermetrics, Zapier paid plans)?
3. Are there ways to drive higher ROI on ad spend with Sheets / Data Studio?
4. Is it possible to pull Keyword Research data (like monthly search volume for a keyword)
into Data Studio?
5. Is there another way to pull Phoneburner API (sales dialing tool) data into Google Sheets other than Zapier + Webhooks?
6. I have two separate lists of data. Is it possible to generate a list of all values from the larger list that are also on the smaller list?
7. I have client data in separate Sheets, one per client. Is it possible to aggregate this data to one master Sheet?

[tonyguarnaccia]

You mentioned a video from Ryan Stuart about how he uses GS in his agency, where do I find that video?

[dannyspeagle]

Please SHARE YOUR SCREEN MORE.

I am trying to follow along and I can not discern much of what you speak of because I cannot see what you see.

(fyi, I am watching this in replay on youtube).

[natewelch]

I wish we could get an MS SQL connector in GDS. One can dream.... Dealing with MS legacy systems. any ideas?