How To Send Excel Information To Google Sheets, Google Calendar & Email With Zapier

[@ExcelForFreelancers]

🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom

[@dorotheeprevot5066]

Thank you ! I made huge progress in excel in only two weeks because of you !

[@ExcelForFreelancers]

That is awesome Dorothee, I am so happy to hear that. Thank you for your Likes, Shares & Comments. It really helps.

[@damnmynamestaken]

This entire channel is by far the best I've seen. amazing work.

[@ExcelForFreelancers]

Thanks so much. I really do appreciate that, and work hard to give my best each and every week.

[@SyedMuzammilMahasanShahi]

This is really amazing. thank you

[@ExcelForFreelancers]

Thank you so much.

[@mdsaiful6294]

Nice video 😊

[@ExcelForFreelancers]

Thank you so very much, I really appreciate that Saiful

[@careair5516]

After encapsulate a program, it is the bigger environment that fails the security check. Major companies should look into this ethical issue as a beacon for corporate social responsibility.

[@ExcelForFreelancers]

Thanks for your comment

[@moriomakter3153]

Nice video

[@ExcelForFreelancers]

Thanks so much Moriom. Thank you for your Likes, Shares & Comments. It really helps.

[@yacomedinav]

Thanks for sharing all this amazing tutorials! I have a question, Could it be possible to send a copy of a excel document to a google account (just to have a security copy in the cloud)? Im sending this message from Perú and i will recommend it

[@ExcelForFreelancers]

Hi thanks for your comment and question. I am glad you like the videos. Yes for sure to answer your question. There are many ways you can use Google Drive (now called Google Backup and Sync) This is just a folder that sits on your computer. Anything you save in this folder gets backed up to Google Drive. (Just like DropBox or OneDrive). You can open simple xlsx files in Google Drive in a browser but you cannot open macro-enabled files (xlsm) in Google Drive. For a backup soruce, it works great, even if the files are macro-enabled. Thanks so much, all the way from Peru.

[@Chrisymcmb]

That's Cool Man

[@ExcelForFreelancers]

Thanks a lot. I am glad you liked it.

[@CesarPeron]

Awesome video, would you help me? I need the same thing but from G.Sheet to G.Calendar

[@ExcelForFreelancers]

HI Cesar, Thanks very much. I am focused on Excel for now however I am sure there are ways to do this with scripts but I am not familiar with them. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question with code screenshots here:bit.ly/groupexcel

[@stewartthomson3729]

Hi, thanks for the tutorial - I have a question, is there a way to edit the range to cover more than one value to be sent to the G.sheet? If someone was to enter 100 names into column F could these all be sent at once to the sheet? I can't figure it out !

[@ExcelForFreelancers]

Hi Stewart, thanks for your question. There may be a way to sync large ranges of data without Zapier using some other methods. Can you please post this question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 15,000 Excel experts who may have done this type of sync before with Google Sheets.

[@thepkhealthcareadvice]

Wow!!!

[@ExcelForFreelancers]

Thank you very much. I do appreciate that.

[@c3pol1]

Hi, thank you very much for the video. Is it possible to pass the excel data to Zapier if we generate the data in Excel using an ODBC connection? So on worksheet refresh, can we capture only the added rows and only send the newly added rows to Zapier webhook?

[@ExcelForFreelancers]

Hi Rashid, Thanks for your question, any information can be passed to Zapier, within limits (perhaps a few fields of data), Since Zapier does not work directly with Desktop Excel (Only Excel Business Web App) This means we need a 3rd party like Google sheets, So this will help using ODBC, however its the entire table. There are possibilities using the GET statement that may allow you to retrieve specific data, however that can be done in another training. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel

[@c3pol1]

Thank you for your explanation. I will certainly join the group. To clarify further, I was wondering if this could be achieved using the method you described in the video (by modifying the code). So instead of assigning the Macro to a button, we can activate in On Refresh and have it only send the newly added rows.

[@ExcelForFreelancers]

Yes that is correct. The refresh macro can be run at any point you like. You can track the # of rows so that only new rows are pulled into the database file. Give it a try and if you run into any specific issues feel free to post your detailed questions (with screenshots or upload) in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel

[@user-wm1ob3vs2t]

Hello Randy when i run the program, both your download and both when i write it myself, i get a bug on the "objHTTP.Open "PATCH", URL, False". is there something i need to define in my excel? thanks in advance

[@ExcelForFreelancers]

Hi there I have not run into that error myself however if you upload the workbook and issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 20,000 members who can help you with this issue. Thanks very much.

[@rakeshbond009]

Sir how can we use WebHook to update,Delete data in Google Sheet from excel

[@ExcelForFreelancers]

Hi Rakesh, thanks for your comment. You can use the webhooks similar to this with a few modifications. You can have a look on the www.Zapier.com site to learn the details on Updating and Deleting data in Google sheets. (I will write this down as a possible training video in the near future)

[@ValmisFilm]

Thank you very much! This worked! BUT Zapier for free has really low limits... 100 tasks - mean 100 times you can send the data - and you are blocked! Any other way to do this?

[@ExcelForFreelancers]

Hi thanks for your comment, almost every free option is going to have limits, however you can use Google Forms, Google Sheets with Excel Data connection without any costs or limits. Thanks so much.

[@ValmisFilm]

@@ExcelForFreelancers Thanks! Alright, but how do you make that work? is there a video?

[@ExcelForFreelancers]

You would just make the Google Sheets a public link then use a data connection in Excel to pull the data.

[@Ian_Enterprise]

Hello, Can you tell me when i use Alt+Return into the issue field to enter some more text And i send it, it won't show the text under it at separated lines but just at 1 line ? Please tell me how i can fix that please. I tried to use: Issue = Replace(Issue, Chr(9), "") But didn't work. Thanks.

[@Ian_Enterprise]

Hello Randy, No worries, I fix my problem :D Still awesome vid and Tutorials Love your work ;) for the one's has the same problem with ALT+Return Here is my code: Dim myCell As Range For Each myCell In .Range("I8") myCell.Value = Replace(myCell, vbLf, "") Next Cheers!

[@ExcelForFreelancers]

I am glad yo were able to get it fixed and thanks so much for your support.