How To Sync Google Forms To Excel and Automatically Send Custom Email Responses

In this week’s training, I will show you how to Sync Google Forms To Excel and Automatically Send Custom Email Responses.

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:

EXCEL COURSES:

EXCEL PRODUCTS:

TIMESTAMPS:
0:00 - Introduction
8:02 - Refresh Responses
13:52 - Send Responses
24:07 - Open Workbook

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #googleformssync #customemail #googleformstoexcel

[Sebastien_Frederic]

No words can describe how interesting are you videos. Thanks a lot!

[GerardKuijpers]

Fantastic!!!
I learned at least five things I didn't even know could be done

[erickwang]

Wow thankyou for the amazing tutorial. (Subscribed & notif on for your channel !!).

But i have a question.
How to prevent your excel apps from sending same email response to the data when it is refresh since everything run automatically?, ,
I mean if we add new data in google form and refresh the query, , it will change the whole data and there's high chance the email response send the same email to previous data, ,
Thank you

[ryanlarue]

Great video! Solved a huge logistic problem I've been facing!

[tannerflock]

Such a good video thank you so much! I was curious that if there was sensitive information would you be able to do it this way? I'm not to sure who can query the results when you publish it to the web. If anyone knows i'd be extremely grateful!

[sabeeralii]

Hi,
Your content is very interesting.
I need a help from you.

Can you please let me know how to prefill employees details when the employee enter his employee I'd.

If he enter his employee I'd, his entire information should be filled automatically.

[ryanjefferis]

Hi, another great video, but do you know of any way to sync Google Forms to MS Access?

[uniQue_XL]

Thanks for sharing.
By the way, no Macro requeir as you can use Power Query to pull the Data into Power Query Editor and make manipulation on data and pass it into Power Pivot for more options...

[benmoreton]

Amazing tutorial, thank you.

I want to use this on a weekly basis to create a graph showing a winner voted for by people!

Is there a way to delete responses on google forms and have that update in excel?

So far when I delete all responses the old ones stay in excel and I have to create a new sheets for the following weeks results

I’d like to keep it all as one if possible

[Cosmicsciences]

Hi sir can we do this with Microsoft forms

[pierregyselinx]

Hello ! It seemed to be very nice... But I use a corporate account and the web-publication is limited to "Corporate". In Excel, I used obviously the same account to retrieve the publication. But the result is not the data included in the google sheet, but something like a request to log in...

[pnkskr]

Hi Randy,


What about data that I do not want visible to the public? When I hit publish to web, it says that it makes the data visible to anyone but I am dealing with personal information, is it possible to do this and keep the data private?

[lynxx]

hi Randy great Video. I need some help, please. for some reason when I bring the data over it opens a new sheet. Any suggestions. im using office 365

[softwareguide]

I love your tutorials keep up the good work

[AandAcreations]

Hi Randy great video Thanks!!
I need some help, please. I am in Mexico and use Spanish, for some reason when I bring the data over, into excel all of de special character like ñ, Ñ, á, é, í, ó, ú pass like ñ, á, á... I am thinking on a macro to replace the characters there is consistency on the characters, but is there a way to correct this in the properties of the connection? or options? Thanks. my Excel is in English, and the code.. excel 2016

[daskarateacademy]

Great Video... Sir. Thank you so much to put a lot of effort and potentials. Really appreciate it.

[ms.tamlynhardy]

I tried doing this in Google sheets but can't find an option for 'Data from Web'. Is this possible in Google Sheets?

[everythingandnothing]

Can't download this workbook, regardless of browser. Tried many times. No download activated today. Tried both links. Can you please assist? Thanks.

[vickybanthia]

How to create error quality feedback form for employees on excel