Addresses into a Location column

Coming soon: the Text to Location automation block and the GEO.LOCATION function turn an address into a position in a Location column.

Coming soon: with the next version of General Caster. This page shows how it will work.

The Text to Location automation block turns an address into a position in a Location column, with the full address as Google Maps finds it. The board’s map view and the map recipe then work from a plain text.

Set it up

  1. In monday’s automation builder, choose a trigger on an item, for example When Address changes.
  2. Add the General Caster block Text to Location.
  3. Write the address: pick the column from the list, or build it with a formula, {Street} & ", " & {City} & ", " & {Country}.
  4. Choose the Location column to write into.

When the address changes, the position is found and written. “Via Roma 1, Milano” becomes the position of Via Roma, 1, 20121 Milano MI, Italia, in the language of the person the automation runs for.

Good to know

  • Credits: 3 per conversion. Only 1 when nothing is converted: an empty address, an address not found, or a position already in the column.
  • Plans: paid plans only, because each conversion is a request to Google that costs us money.
  • Empty address: the Location column is cleared.
  • Address not found: you get a monday notification with the address, the automation stays on and the column is left as it is. Add the city or the country to the address.
  • One item at a time: the block works on the item of the trigger. It doesn’t run with a scheduled trigger.
  • Privacy: the address text is sent to Google Maps Platform. We keep the position found for 30 days, so the same address isn’t asked again. See What data General Caster processes.
  • The block’s output, address, is the address Google found, for the next steps of the automation.

In a formula: GEO.LOCATION

In the new recipes and in the Calculate a Formula block, GEO.LOCATION(address, [part]) does the same inside a formula:

Formula Gives
GEO.LOCATION({Address}) 45.4654219:9.1859243:Via Roma, 1, 20121 Milano MI, Italia, ready to write into a Location column
GEO.LOCATION({Street} & ", " & {City}, "address") Via Roma, 1, 20121 Milano MI, Italia
GEO.LOCATION({Address}, "lat"), "lng" The latitude or the longitude, as a number
GEO.LOCATION({Address}, "city") Milano
GEO.LOCATION({Address}, "region") Lombardia
GEO.LOCATION({Address}, "country"), "country_code" Italia, IT
IFERROR(GEO.LOCATION({Address}, "address"), "Check the address") A text of yours when the address isn’t found

The other parts are "street", "number", "postcode" and "province". A part the address doesn’t have (a country has no street) is empty. Names come in the language of the person the automation runs for, and converting the same address for several parts asks Google once.

Each address found costs 2 credits more than the formula, up to 10 different addresses in one formula. As the block, it isn’t in the Free plan and works on the item of the trigger, not with a scheduled trigger or with MONDAY.GROUP and MONDAY.BOARD. An address not found, without IFERROR, sends you a notification and the automation stays on.

Still stuck?

Check your formula step by step, or ask us: we usually answer within one business day.