How to Create an address block in Google Sheets™ from your Gmail™ contacts using AddressBlockApp

Welcome to our tutorial on harnessing the power of AddressBlock to streamline your business management using spreadsheets. Follow these steps to make your workflow more efficient:

Adding Contacts

Open the AddressBlock menu and select Lookup by Name.

Export your selected Gmail™ contacts to an Outlook™ CSV file. Open it and 'Select all' (Ctrl+A) then press (Ctrl+C) to copy. Paste them (Ctl+V) in the green shaded (First Name) cell (B1) on the contacts sheet in the AddressBlockApp.
Select the 'Name' dropdown box (B1) on the Address sheet. Copy and paste it in the desired cell on your form or spreadsheet. (note the cell letter and number)
Select the Target cell on the Address sheet and enter the noted letter and number of your target cell. Select 'Target formulas by Name' in the menu.
When complete, select each formula in the formula bar press (Ctl+A) to select the formula then (Ctl+C) to copy. Select the desired cell on your form or speedsheet where you want the information to appear. In the formula bar, press (Ctl+A) then (Ctl+V) to paste, press Enter. Repeat this step for the rest of your address block.

Open the AddressBlock menu and select Lookup by Company. Export your selected contacts to an Outlook™ CSV file. Open it and 'Select all' (Ctrl+A) then press (Ctrl+C) to copy. Paste them (Ctl+V) in the green shaded (First Name) cell (C1) on the contacts1 sheet in the AddressBlockApp. Use previous steps to create your Address Block.

Congratulations! You've successfully integrated your contacts into your management workflow using the AddressBlock App. Enjoy the benefits of a more organized and efficient management experience.