Pull Data from sheets into Area120Tables

[CANA-IT]

Hello,

I am working in Area120Tables.
I have a couple app scripts which work in google sheets to:

1. Calculate Origin Location and Destination into miles;

2. Convert Zip code into Country, State, City, Lat, Long.

I can't figure out how to pull the data from the google sheet and populate the appropriate columns in my Area 120 Table.

Any help would be greatly appreciated.

Maybe @cwlind you could take a shot at it. You seem to be the Genius when it comes to these things.

Kurt