VBA Code to Complete/ validate address in excel using Google API key

[Noni]

Hi, I've got my google API key and want to use it to complete broken/incomplete addresses using vba code.
addresses in column A sometimes come without suburb or postcode or State.

AddressCleansing.xlsm
	A	B	C	D	E	F
1	Incomplete Addresses	Cleaned Required Addresses	Post Code	Street Addresses	Suburb	State
2	12 April Street WA 6980
3	15/80 Gale Ave Adelaide SA
4	6 Wool Cres Woy Woy 3456
5
Sheet1

desired result after running code:

AddressCleansing.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Incomplete Addresses	Cleaned Required Addresses	Post Code	Street Addresses	Suburb	State
2	12 April Street WA 6980	12 April Street Perth WA	6980	12 April Street	Perth	WA
3	15/80 Gale Ave Adelaide SA	15/80 Gale Ave Adelaide SA	5678	15/80 Gale Ave	Adelaide	SA
4	6 Wool Cres Woy Woy 3456	6 Wool Cres Woy Woy VIC	3456	6 Wool Cres Woy Woy	Woy Woy	VIC
5
6
7
Sheet1

Appreciated!