Stack Overflow
Stack Overflow

Questions tagged [google-docs]

Questions related to interacting with Google word processing Documents programmatically. Usage questions about the web application should be posted at Web Applications Stack Exchange.

Google Docs is a cloud-based application and service for creating and collaborating on word processing documents. The service supports an internal API for Google Apps Script as well as an External API.

Usage questions about the web application should be posted at Web Applications Stack Exchange or the Google Drive Help Center instead of here.

Note: Google has historically used the brand "Google Docs" to encompass a suite of products, but since conforming to that would introduce ambiguity here, the tag is specifically for word processing documents while refers to the suite.

3539 questions
45
votes
4 answers

Google Surveys -- a way to pass URL parameters into survey?

I have created a Google Survey and I want to be able to pass URL parameters into the survey so that I can track where responses are coming from. Ideally these URL parameters will be populated into the spreadsheet. I have tried something like…
Nathan Lippi
  • 4,967
  • 5
  • 25
  • 29
45
votes
4 answers

What are the Google Apps MIME Types in Google Docs and Google Drive?

What are the MIME types for each of the following file extensions: gdoc gslide gsheet gdraw
Edd
  • 8,402
  • 14
  • 47
  • 73
43
votes
5 answers

Google Docs Viewer occasionally failing to load content in iframe

I'm having an issue with the Google Docs viewer that is causing a nightmare to solve because it only happens intermittently. I'm looking for guidance on how to make the content in the iframe load everytime without issue as it should. Steps to…
thatguy
  • 797
  • 2
  • 9
  • 17
42
votes
1 answer

Creating anchored comments programmatically in Google Docs

I have been unable to programmatically create a comment that is anchored to specific text in a Google Doc using an app script with the document. Google documentation about how to create an anchored comment using the Google Drive…
Parker
  • 548
  • 4
  • 6
42
votes
10 answers

Insert date time in google document

I would like to insert a timestamp (date and/or time) into Google Documents. The support documentation () says that there should be a keyboard shortcut, but it does not work in my environment (Win7 + IE9). Can anyone provide me with a Google Apps…
rbregt
  • 437
  • 1
  • 4
  • 3
40
votes
13 answers

Download a spreadsheet from Google Drive / Workspace using Python

Can you produce a Python example of how to download a Google Sheets spreadsheet given its key and worksheet ID (gid)? I can't. I've scoured versions 1, 2 and 3 of the API. I'm having no luck, I can't figure out their compilcated ATOM-like feeds…
a paid nerd
  • 30,702
  • 30
  • 134
  • 179
37
votes
5 answers

Is it possible to force a copy of a protected Google doc?

Google docs can “lock” a page so that it’s impossible to copy from its text. This seems wrong to me; shouldn't a computer’s ability to copy and paste be intrinsic? I can’t understand how a webpage can “overstep” its authority and prevent my computer…
Mr_Dave
  • 547
  • 1
  • 8
  • 17
32
votes
4 answers

Spreadsheets get unique names but ignore blank cells

I would like to use spreadsheets to get all unique names from Column A in a table but in the same time I would like blank cells to be ignored. So far I've got this formula that returns all of the unique names from column A but I don't know how to go…
DIzZy
  • 323
  • 1
  • 3
  • 4
31
votes
2 answers

JSON import to Excel

Is it possible to script JSON calls in a macro? I want to get a JSON string through an API connection. It looks like the problem is Excel expects the parameters to be passed in the HTML-string, but JSON passes parameters in the HTML body. Any…
user1034706
  • 311
  • 1
  • 3
  • 3
31
votes
5 answers

How to force newlines in Google Apps jsdoc descriptions

I can't figure out how in a Google Apps Script to display this correctly. I need it to display new lines in the jsdoc output(e.g. when the function tooltip window comes up in a Spreadheet functions.) I have tried html like however it is just…
masshuu
  • 471
  • 1
  • 4
  • 6
30
votes
3 answers

Google docs - Access text changes realtime

Goal Our users work in Google Docs. The text they write will be read to them as they type using text-to-speech. It should work across as many platforms and browsers as possible. Our solution This seems to fit the Google Apps Script, it works on…
Mr. JWolf
  • 1,375
  • 2
  • 14
  • 33
30
votes
4 answers

How do you create a document in Google Docs programmatically?

The documentation for Google Documents List API, seems to say that you can create a local document and upload it. Is there no way to actually create and edit a document on Google Docs through an API?
snoopy
  • 603
  • 2
  • 6
  • 12
29
votes
5 answers

Embed editable Google Docs spreadsheet without header & toolbar

I have the requirement to embed a Google Docs spreadsheet on a webpage, but it needs to be just the editable cells, without the Google navigation and toolbar at the top. I can't find a reference to the querystring variables for embedding Google docs…
Dan
  • 5,836
  • 22
  • 86
  • 140
29
votes
4 answers

How to correct spelling in google docs using keyboard shortcut?

I would like to be able to replace a misspelled word in a Google doc with Google's recommended correction with a keyboard shortcut, instead of having to mouseover the word, right click on it, and select the corrected word. Is there any way to do…
tomh
  • 369
  • 1
  • 4
  • 10
29
votes
10 answers

Google Docs viewer returning 204 responses, no longer working, alternatives?

UPDATE 2016-11-16 9:53am EST It appears many people are still seeing 204 responses even though Google has claimed to have "fixed" the problem. When I myself tested the loading of a document 50 times, 3 of those times Google returned a 204 response.…
Art Geigel
  • 1,915
  • 3
  • 22
  • 24
1
2
3
…
99 100