Geodata Online — a Tool for Tables

Geodata Online — a Tool for Tables is a Google Apps Script-based tool that operates inside Google Sheets and helps automate the processing of tabular data via the GeoData.online API. Users launch the required scenario directly from the Google Sheets menu, and the processing results are written back into the current spreadsheet.

The tool is designed for teams and specialists who work with addresses, geodata, and full names (first, last, and middle names) in spreadsheets and want to perform bulk processing without manually copying data between services.

Доступ до онлайн-довідників актуальних адрес України, Казахстану, Польщі, Чехії, Італії, Естонії, Румунії, Болгарії, Франції та Данії

Обробка баз даних: актуалізуємо, доповнюємо, структуруємо адресні бази даних

Додаткові сервіси:
пошук імені, зворотне геокодування, оцифровка анкет

Features

Geodata Online — a Tool for Tables provides the following key capabilities:

Address parsing into individual components

Full address composition from input data

Preparation of address fields for contracts and postal envelopes

Transliteration of address data for envelopes

Reverse geocoding based on coordinates

City detection by IP address

Full name parsing into individual components

Declension and transliteration of full names

How Users Work with the Tool

The user opens the Google Sheet with the tool installed.

The required input columns are added to the spreadsheet for the chosen scenario, such as raw_address, raw_lat, raw_long, raw_ip, or raw_fullname.

The user completes authorization in their GeoData.online account via the built-in dialog.

After authorization, the user selects the required scenario from the GeoData.online menu.

The tool processes rows in batches, sends only the data required for the selected scenario to the GeoData.online API, and writes the results back into the current Google Sheet.

Processing status and progress are displayed in the spreadsheet so the user can see which rows have already been processed.

How Data Processing Works

The tool operates exclusively within the current Google Sheet opened by the user. It reads input values from the spreadsheet columns, sends only the data required for the selected scenario to the GeoData.online API, retrieves the processed result, and writes it back into the same spreadsheet.

For large datasets, the tool uses batch processing and Google Apps Script service triggers to continue processing in parts without requiring manual intervention for each row.

Data Used by the Tool

The tool uses only the data required to execute the selected scenario:

Data from the current Google Sheet opened by the user

GeoData.online authorization parameters and processing state, stored in Apps Script properties

requests to the external GeoData.online API for address, geodata, and full name processing functions

The tool is not intended to access Gmail, Google Calendar, Google Contacts, or any other Google services unrelated to the current spreadsheet.

User Value

Geodata Online — a Tool for Tables helps users

Reduce manual work when processing addresses and full names

Prepare data arrays faster for logistics, contracts, envelopes, and CRM processes

Standardize processing results within a single Google Sheet

Run bulk processing without writing code or making manual API requests

Instructions

Authorization

In the GeoData.online menu, select "🔐 Authorization" and enter your login and password.

If you don’t have an account yet, register here: Register at GeoData.online

Starting Processing

In the "GeoData.online" menu, open the "Addresses", "Geo Services", or "Full Names" submenu and select the required scenario. Processing is performed in batches; the batch size can be configured in the code (BATCH_SIZE).

Auto-Continuation

The script automatically runs every minute (BATCH_DELAY_MIN = 1) until all rows in the selected scenario have been processed. Once finished, the trigger is removed automatically.

Input Data Template

Row 1 must contain column headers with the raw_* prefix:

Addresses: raw_address
Reverse geocoding: raw_lat, raw_long
City by IP: raw_ip
Full names: raw_fullname

Processing progress is shown in the api_status column header, for example: api_status
progress: 10/50 (20%).

The api_status field is added automatically to the first empty cell in row 1. Immediately after it, the api_status_ts field is created automatically.

Only rows where api_status is empty are processed. If a row already has a status, it is skipped.

Automatic Token Refresh

If the token has expired, the system attempts to refresh it automatically. If the refresh fails, an error message is displayed and you will need to re-authorize.

Completion

Once all rows have been processed, the trigger is removed automatically and the status in the spreadsheet shows 100%.

Menu Description

The following groups are available in the “GeoData.online” menu:

Addresses — 🅰 Detailed parsing (43), 🔤 Auto-complete (1), ✉️ Envelope layout (6), ✉️ Transliteration for envelopes (6).
Geo Services — 🌐 Reverse geocoding (40), ℹ️ City by IP (27).
Full Names — 👤 Component parsing (7), 🗣 Declension + transliteration (23).
🟥 Stop Processing — sets a stop flag and removes the trigger; the current batch stops or does not continue further.
🔐 Authorization — opens a dialog for entering your email and password; after successful authorization, the token is saved for API calls.
Check Balance — shows the current balance and account status.
Reset Authorization — deletes the saved token (logout) and opens the authorization form for re-login.
❔ Help for GeoData.online — opens this help window with instructions and links.

The number in parentheses next to a menu item (e.g., 43, 1, 6, 40, 27, 7, 23) is the approximate number of columns the script will automatically add to the spreadsheet for that scenario.

API output formatting: SexID: 1 = male, 2 = female; true/false = yes/no.

Payment and Pricing

Note: all API requests are paid. Pricing details, packages, and terms of use can be found on the pricing page: View GeoData.online Pricing.

View GeoData.online Pricing.

Tips for Authorization Errors

If you see an incorrect credentials message when trying to authorize (e.g., invalid_grant), try the following:

Log in to account.geodata.online manually and reset your password if necessary.
Make sure your account has been confirmed via email and there are no blocks or CAPTCHA requirements.
If the issue persists, contact GeoData support with the logs (HTTP status code and response body).