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.

2953 questions
41
votes
2 answers

Debugging a custom function in Google Apps Script

I am trying to create my first custom function for a Google Spreadsheet in Apps Script and I am having a hard time using the debugger. I am working on the custom function demo code from the Google documentation and I have set a breakpoint in the…
41
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
  • 7,660
  • 14
  • 44
  • 70
40
votes
7 answers

How can I create a hyperlink in the middle of cell text?

In google spreadsheets, it is possible to add a hyperlink to a cell as: =hyperlink("www.google.com", "search the web") This will show the text search the web which will hyperlink to google. However, I am wondering: How can this rule be inserting…
dublintech
  • 14,457
  • 27
  • 77
  • 110
39
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
  • 407
  • 1
  • 4
  • 3
37
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…
36
votes
13 answers

Download a spreadsheet from Google Docs using Python

Can you produce a Python example of how to download a Google Docs 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 API,…
a paid nerd
  • 28,574
  • 30
  • 121
  • 167
36
votes
2 answers

Is it possible to send HTTP request from inside Google docs?

I want to send an HTTP request to some REST service from Google drive spreadsheet. Is this possible?
Muhammad Hewedy
  • 26,344
  • 42
  • 116
  • 201
34
votes
1 answer

How does Google Docs deal with editing collisions?

I've been toying around with writing my own Javascript editor, with functionality similar to Google Docs (allowing multiple people to work on it at the same time). One thing I don't understand: Let's say you've got User A and User B connected…
33
votes
2 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
  • 695
  • 1
  • 6
  • 17
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
30
votes
2 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…
29
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
  • 469
  • 1
  • 7
  • 15
29
votes
3 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,227
  • 5
  • 23
  • 29
29
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
  • 583
  • 2
  • 5
  • 12
26
votes
6 answers

Is there a good R API for accessing Google Docs?

I'm using R for data analysis, and I'm sharing some data with collaborators via Google docs. Is there a simple interface that I can use to access a R data.frame object to and from a Google Docs spreadsheet? If not, is there a similar API in other…
James Thompson
  • 43,044
  • 17
  • 61
  • 80