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
15
votes
3 answers

How to use Google Docs for Mailer templates?

Is it possible to use Google Docs for Mailer templates? How can I change template variables via API? Basically, I want to keep a template on Google and export it as a PDF file after changing few variables like name, address etc. Is it possible to do…
understack
  • 11,212
  • 24
  • 77
  • 100
14
votes
4 answers

Is there any open source alternative to Google Docs?

I'm looking for an Open Source alternative to Google Docs. Reason I want it is because I want to host it on my computer. Google doesn't allow you to do that. Anyone know of any open source alternatives to Google Docs? I would be grateful if there…
sxingfeng
  • 971
  • 4
  • 15
  • 32
14
votes
2 answers

Block Website Scraping by Google Docs

I run a website that provides various pieces of data in chart/tabular format for people to read. Recently I've noticed an increase in the requests to the website that originate from Google Docs. Looking at the IPs and User Agent, it does appear to…
Peter
  • 1,674
  • 4
  • 27
  • 44
14
votes
2 answers

Convert Google Doc to PDF using Google Script Editior

I've been trying to convert a Google Docs file to a PDF file without having to use the download option. Below is the script I have used in the Script Editor but it doesn't seem to work. I think the error is after the IF statement. function…
14
votes
6 answers

How can developers edit a Google Doc programmatically? Is there a Docs API?

There doesn't seem to be (to my knowledge) an API to edit Google Docs (not spreadsheets, their HTML based documents). Has anyone done something like the? Maybe by downloading the HTML version, editing and uploading the changes?
14
votes
5 answers

Editable grid using html Canvas

I was recently very surprised when I noticed that in the latest iteration of Google Spreadsheets they are rendering the spreadsheet grid using a canvas tag, whereas in the past they used the tried and true
to render the grid. In the…
Danny C
  • 2,980
  • 2
  • 28
  • 20
13
votes
3 answers

Can we upload files to google docs via linux shell script or python

Is it possible to upload files to google docs via commandline or bash or via python. i have plent of stuff to upload but i have only access to command line and shh nothing else. is there way to do
Mirage
  • 30,868
  • 62
  • 166
  • 261
13
votes
2 answers

Using SUMIF correctly on google spreadsheet

I want a cell to give me the sums of the cells above, only when another column has values in it as well. For instance, I want B5 to sum up B1:B4, only when C1:C4 also have values, if a C cell doesn't have a value, then I want the corresponding B…
user28790
  • 133
  • 1
  • 1
  • 4
12
votes
1 answer

Google docs : make one or more landscape page on a portrait document

I am working on a document on google doc. I have a large table to add to my document and I am wondering, is there any way to make one or more landscape pages on a portrait document. I tried to insert a page break and to change after the orientation…
omar
  • 305
  • 1
  • 3
  • 10
12
votes
2 answers

Clickable Phone numbers in Google Docs

Is there a way to make phone numbers clickable in Google Docs similar to MS Word like here? Please note that this can be done in Google Sheets using: =HYPERLINK("tel:1234567890", "Call Me") I am asking for Docs. Thank you.
Ahmet
  • 908
  • 1
  • 17
  • 26
12
votes
1 answer

How do I name a range in google docs?

The Google Apps Script API for Docs has a number of methods defined that work with Named Ranges in Docs. While I am familiar with Named Ranges in Sheets, I cannot find a way to name a range in Docs. Does anyone know how to name a range using the…
Jon Pellant
  • 388
  • 3
  • 13
12
votes
2 answers

google docs iframe - change padding

I have an embedded iframe that has been created publishing a google doc. The iframe automatically applies a large padding to its body resulting in the text being a very narrow and ugly column. I have to change that. I have tried to create a custom…
NoIdeaHowToFixThis
  • 4,484
  • 2
  • 34
  • 69
12
votes
1 answer

Google Doc Viewer: Which formats are really supported?

I'm using Google Docs Viewer to embed all kind of documents. However I am having trouble to find out which formats are really supported. On the offical Docs Viewer website (https://docs.google.com/viewer) Google links to a nice list of all supported…
Michaël
  • 143
  • 1
  • 2
  • 10
12
votes
7 answers

scripting a google docs form submission

I'm trying to create a bookmarklet that parses a page and sends the results to a googledocs spreadsheet via a form that I've defined. The relevent bit of the script is: var form = document.createElement("form"); form.action =…
justSteve
  • 5,444
  • 19
  • 72
  • 137
11
votes
3 answers

How can I automatically download backups of a Google Docs Spreadsheet?

I am currently using a Google Form to allow people to submit information that is stored in a Google Docs Spreadsheet. I was wondering if it is possible to automate a backup of the spreadsheet at regular intervals. For example, every Friday the…
Ryan
  • 2,433
  • 5
  • 31
  • 41