aloha710.files.wordpress.com  · web viewselect google drive & login to your google account....

17
Select Google Drive & login to your Google account.

Upload: others

Post on 21-Sep-2020

3 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Select Google Drive & login to your Google account.

Page 2: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Open a Googlesheet

Page 3: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

\ox to

This is a Googlesheet

Page 4: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Locate the folder where you save your text file to & open it completely so that it fills your entire screen.

Page 5: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Select ALL of the lines from top to bottom of the entire text file

Once all the lines are selected, right click & select COPY

Close the text file.Go back to the Google Drive & the opened Googlesheet & Right click & paste.

Page 6: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Place cursor between Column A & Column B & double click to expand the column.

Double Click HERE

Page 7: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Insert a column to enter the date & time.

Double click between Columns A & B and B &C to expand both columns.Review each line & delete empty rows.

Page 8: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Enter Time (military) for 4 cells (downwards) at 5 minute intervals & select the completed first 4 cells & hover over the bottom corner of the 4 cells & a T will appear. Drag T down to the last cell & let go. The column will auto-populate with the date & time.

Lose

Page 9: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Close Googlesheet.

Close Googlesheet

Page 10: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Right click & select Download on the Googlesheet. It will download to your DOWNLOADS folder on your computer. DO NOT open the DOWNLOADED version.Open Hootsuite & Open Tweet box to expose the Bulk Message Uploader.

Click Bulk Message Uploader

Page 11: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Click on Choose File & locate the Googlesheet in your DOWNLOADS folder.

Page 12: aloha710.files.wordpress.com  · Web viewSelect Google Drive & login to your Google account. Open a Googlesheet \ox to . This is a . Googlesheet. Locate the folder where you save

Click OPEN to insert into Hootsuite Bulk Uploader.

Then click on the Hootsuite SUBMIT button