Questions tagged [google-sheets]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
25 views

Setting up a dynamic spreadsheet to join with feature layer in ArcMap

I am building a map of about 500 storage units that are being acquired and relocated, each unit is represented as a polygon. Each polygon is coded by Unit Number and will go through about 5 different ...
kkaszas's user avatar
  • 290
0 votes
0 answers
1k views

SQL query into a Google Apps Script (*.gs)

I am beginner in .gs and javascript (.js) code and I want to write a Google Apps script including an SQL query to apply it to one or more Google Sheets tabs : tab where I write my *.gs code : ...
Philippe SCHITTER's user avatar
3 votes
0 answers
229 views

Using data in google sheets as input to add csv layer to QGIS

I have a google sheets spreadsheet that contains XCoord and YCoord columns and some other columns. I want to use this sheet as (preferably live) input to create a point layer in QGIS. My approach is ...
Willem's user avatar
  • 31
1 vote
2 answers
526 views

Connect a Google Spreadsheet for importing a FeatureCollection to Google Earth Engine

I have a google spreadsheet consisting a feature collection table. Is it possible to import the table in Google Earth Engine? I am a new learner of Earth Engine and was thinking that we have to upload ...
Padmanabha's user avatar
  • 1,384
0 votes
1 answer
233 views

Files in shared Google Drive not appearing in ArcGIS Online 'Add Item from Cloud Drive'

I am trying to add a Google Sheet to ArcGIS Online through the 'Add item from cloud drive' option as per https://support.esri.com/en/technical-article/000022290. It works pretty well aside from the ...
mfoster's user avatar
0 votes
1 answer
506 views

Why my Google Sheet document is not updating in ArcGIS Online?

I have a Google Sheet that updates from a survey I have live in Google forms. I added this to my content in ArcGIS and added as a layer to a map. I was sure to set the refresh interval. I have been ...
Pablo Jimenez-Moreno's user avatar
0 votes
2 answers
757 views

AGOL webhook to Integromat/Google Sheets

I have a feature layer in AGOL. Whenever edits are made to features in the layer, I want to POST those edits/attributes to an external system for testing purposes. In this case, the external system ...
User1974's user avatar
  • 1,132
3 votes
2 answers
585 views

Adding Google Sheets to ArcGIS Online

I am building a Dashboard that relies on tabular data and that is located in a Google spreadsheet. Since the spreadsheet is dynamic and gets updated constantly, I would like those changes to be ...
Kirstin's user avatar
  • 31
2 votes
2 answers
2k views

Linking Google Sheet to Hosted Feature Layer in ArcGIS Developer Online (free version)

I am trying to create a ArcGIS Online Dashboard that is linked to Google Sheets. I have done this successfully in a regular ArcGIS Online map by publishing the Google Sheet as a CSV file and uploading ...
Sarah's user avatar
  • 53
0 votes
0 answers
145 views

Incorporation the Ordnance Survey map to Sheetsee.js plugin for Leaflet/Mapbox

I am currently using this plugin: https://github.com/jlord/hack-spots which works really nice in conjunction with Google Sheets. My goal is to convert this site into my own purposes. One of the ...
Geographos's user avatar
  • 4,087
-1 votes
1 answer
3k views

Collecting Lat-Long in a Google Docs Form by adding script?

So I need am trying to figure out a way to collect Lat long data and have it saved automatically when I fill a Google form on my phone. Is it possible as retracing address to plot is not possible for ...
Harshit Talwar's user avatar
8 votes
3 answers
5k views

Connecting QGIS to Google spreadsheets

Is there a way to connect directly form QGIS to a Google spreadsheet? The purpose for pulling data from a Google spreadsheet is diverse. This could be to pull coordinate values from a questionnaire ...
ragnvald's user avatar
  • 3,191
2 votes
2 answers
268 views

How to parse an ArcGIS json in google code?

I'd like to be able to programmatically query a feature service api and pull the attribute data (I don't really need the geometry for this) into a google sheet. It seems like it ought to be simple but ...
Carl's user avatar
  • 260
3 votes
0 answers
233 views

Googlesheets CSV auto-update polylines to ArcGIS Online Maps?

I have been able to establish a ArcGIS Online map that auto-updates from a CSV spreadsheet within Google Sheets. The data that is auto-updating is point data with associated tabular data that will ...
Evan Morgan's user avatar
1 vote
0 answers
7k views

Auto Update from Google Sheets to Google Maps Engine?

I have been looking into the Google Maps Engine and I have noticed that you can import data (points) based on a Google Sheets. This got me thinking, could this be used as a way to auto update a ...
Ryan Garnett's user avatar
  • 9,479
1 vote
0 answers
153 views

Linking Google Sheets with PostGIS

I am curious if there is a way to link a PostGIS table with a Google Sheets? Both tables (Post and Google) have a unique ID that can be used as a linkage. I am hoping to be able to build a view ...
Ryan Garnett's user avatar
  • 9,479