Google Sheets and ip-api.com

Google Sheets

Triggers

• Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

• Append rowAppend a single row to the end of a Google Sheet.
• Create spreadsheetCreate a new Google Sheets spreadsheet.
• Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
• Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
• Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
• Clear row valuesClear values in a specific row without deleting the row itself.

ip-api.com

Actions

• Look up an IP addressGeolocate an IP address or a domain name: the country, region and city it is in, its coordinates and time zone, the provider that runs it, and whether it is a proxy, a data centre or a mobile network.
• Look up this workflow's IP addressLook up the address your workflow's requests go out from, and where it is, which is what you need when a third-party API asks you to allow-list the address your calls arrive from.
• Look up several IP addressesGeolocate a list of addresses in one step and get a row for each with where it is and who runs it. Addresses that cannot be located are reported alongside the ones that can.
• Check whether an IP address can be locatedAnswer whether an address can be located at all, and say why not when it cannot: a typo, a private address from inside a local network, or a reserved one such as a loopback. It answers no rather than failing.
• Check an IP address's countryAnswer whether an address is in one of the countries you name, the check behind sending someone to the right regional site, gating a feature by market, or flagging a sign-up from outside the countries you sell in.
• Check an IP address for proxy, VPN or hostingReport what kind of connection an address is on: a proxy, VPN or Tor exit node, a data centre, or a mobile network. The first two are flagged together, which is the usual signal that a form submission is not coming from where it claims to be.