You generally need geocoded location data to query the API, but the API can generate that for you if you don’t have it (like the original poster). You’d want to use a GET action because the Google Maps API uses GET. :slightly_smiling_face:īut, if you’re intent on using the Google Maps API and Zapier to do something else with those geocoded addresses you can just make an action that triggers on a new record (or a new record in a view) and use the Zapier Webhooks action to process the API request. But, if they implement field summary functions for formula fields one of these days that’ll change. It’d be nice if you could keep it all in one table but I haven’t figured out a way to roll up all the records in the same table and I’m pretty sure Airtable told me that can’t be done about three months ago. This is slightly easier to do with the same approach while using the Airtable API, and you can do a lot more with that URL afterwards, but if you want to keep it in Airtable you have to take those extra steps-at least, I think that’s the case. I think you can just prepend the Google Maps URL to that by putting it in quotes and sticking an & between it and the ARRAYJOIN() function but I’m not sure if rollups are that flexible. If you already store your geocoded addresses in the lat,lon format in a text field (or use a formula field to combine them that way if not: latitude&’,’&longitude is the basic formula, btw, presuming those are your field names for each), you can just make a new table in your base that links to the table with addresses and uses a rollup field to combine them with the ARRAYJOIN() function using // (the two forward slashes) as your separator. Two, however, will just make them points on the map (and the first one the “origin” with the familiar red marker). A single forward slash will tell Google Maps you want directions between all of these places. Append the latitude and longitude coordinates to the URL in this format: lat,long//lat,long//lat,long//lat,longīasically, latitude and longitude are separated by a comma (as per the usual) and each set of coordinates is separated by two forward slashes.You can just build a URL directly in Airtable like this: a checkbox called “Zapier” so that records in your normal view only get added to the filtered view if that checkbox is checked, thereby preventing Zapier from seeing any new records until you’re ready for it to see them).Īctually, if you’re just trying to make a map with a bunch of locations using geocoded addresses (lat/lon coordinates) then you don’t even need the Google Maps API. You can either do it on new records, or if you have a bunch of records (or don’t want to risk Zapier running before you finish typing one in) you can create a view that filters out anything that doesn’t have a specific state (e.g. If you need something more specific, though, you can use Zapier and the Google Maps API to do this pretty easily. We’re going to use the On2Air Scheduler for this automation.If you have Blocks you can just use the Maps block to do this. You can also choose to use the function in an Airtable Automation inside your base, add it to an Airtable Script, use it in a Zapier zap, or in a custom app. You can choose to process it instantly, every few minutes, hourly, daily, weekly, or monthly. With On2Air, you can use our built-in Scheduler to choose a specific time to process your automation. Now, we just need to choose how, where, and when you want it to run. You’ve done the initial setup and tested your function successfully. The last sync shows you the date and time of the last time the function synced, so you’ll always know if it’s up-to-date. The Record ID is the unique ID for that specific record. You’ll also notice two additional columns added – and. When you sync Airtable and Google Sheets, you get to use the best features of both apps. And despite all the complex functionality, it’s still an app that’s easy to navigate. With Airtable, you can create bases that use multiple field types for better data organization, and you can create dynamic links between your records to find everything that’s connected. With Google Sheets, you can do advanced reporting, complex charts, collaborate with users already using Google Workspace, and use formulas on a cell-by-cell basis. Spreadsheets have long provided a powerful way of storing and analyzing important information in a separated, easy-to-filter and sort method. Using Airtable and Google Sheets to Analyze Data
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |