Each row of your spreadsheet file should represent one location. Data should be separated into fields. The first line should be the header line explaining the contents of each column and shouldn't renamed after you connected the fields in the Nearest! Element connector.
To learn more about formatting the data (i.e. addresses, opening hours, ...) please check out the Data types section.
Importing and synchronizing
To start bulk importing from a URL go to Import & sync and Create import. In Import sources select google as your import type and add the Google Doc ID.
After clicking Analyze we will analyze your file and try to find your locations and the correct data type. After clicking Save you'll need to connect the found fields to your location elements.