Create mailing labels from Google Sheets for free

 
These instructions are taken from this Youtube video: 
https://www.youtube.com/watch?v=nCK7l14pLTI

You'll Need Three Things:

1. Google sheets with names and addresses
2. Autocrat which is an extension in google sheets
3. Merge document template which you can find here https://docs.google.com/document/d/1-Xyf4P9ESdlP8Z6uoaFYbrlSWRvcrSInnNpoZbnC1i8/copy

Follow These Steps:

1. Choose autocrat, then open
2. Select new job
3. Give the job a name and then click next
4. Choose template from my desktop
5. Choose select and then next
6. Choose merge tab if you see it
7. Choose columns (this is where you are mapping)
8. Click next, enter a title, leave type as google doc
9. Change the output to be single output mode
10. Choose no to add page break between data rows
11. Click next
12. Leave the rest of the defaults or skip them
13. Click save
14. Click play
15. When it's done, close the window
16. Now you can preview and print the labels doc

Google Contacts Verizon Contacts Oh my

1. Sync Verizon contacts from my phone to Verizon cloud
2. On my phone, go into google contacts
3. Click on my profile picture
4. You will now see you can switch over the Phone - Cloud. Click that
5. Now look where your profile picture used to be. Instead you will see a blue phone
6. Now you are looking at all your Verizon cloud contacts
7. Go into each one, one a time:
1. Click the pencil
2. Click delete (or click move to another account if you want to move it to your google account)
8. You're done. If you moved any to your google account, it should sync and you should see them. Check on both your phone's google account, and your computer's google account. It can take five or ten minutes.
9. Now I can stop verizon contact sync to cloud
10. Go to charging bull and wish prosperity on Saundra (the Verizon agent who tried so hard to help)

Printing labels Christmas 2023

 

1. Go through my Google contacts as best I can
2. See if I can get them to synch with my phone
3. Print at 200% two sided
4. Read them to Mike a few per night, and fix on paper
5. Then update in Google contacts
6. Then do hand-written labels. It's easier that way

Google Drive for Desktop is even worse than Google Backup and Synch

 

All I wanted Google Drive for Windows desktop for was to map my Google drive as a drive, so I could run backups to Google Drive.
It was a fail, as it insists on synching files. 

Could find no way to turn that off.

So instead, I am not running backups to google drive, and I'm keeping Backblaze.