Docs365 Deck Factory

Docs365 Deck Factory

Create Google Slides from Google Sheets data

A Google Sheets™ add-on.

Use Google Sheets™ to quickly create new Google Slides presentations.

See this quick intro YouTube video

Google web store
Install from the Google web store

 

Cell formatting

You use cells formatted in a certain way to control what goes into the new presentation.

The first row should be the Deck Factory column headers.

Column headers

This is how the first spreadsheet row could look like. (Case is important). Only 'Item' and 'Content' need to be present.

Item Content X Y Width Height Color BackgroundColor Bold Italic FontSize FontFamily TextAlign VerticalAlign FirstLineIndent PaddingLeft PaddingRight PaddingTop PaddingBottom MarginLeft MarginRight MarginTop MarginBottom

The item types

Presentation The Content column sets the title of the presentation to create
Slide Creates a new slide
TextBox Adds a textbox to the current slide. The Content column sets the text in the textbox
Image Adds an image to the current slide. The Content column sets the URL
SlideBackground Set the background image of the current slide. The Content column sets the URL
(any of the column headers, e.g. X, Y, Width etc) Sets the corresponding property of the last element, i.e. you don't have to use the columns to set properties, you can just use the two main columns Item and Content and then use these property items to configure element. See the sample below.

The headers

Item The item to add to the presentation (or a property to set for the 'current' (last) element.
Content The value for this Item, depends on the Item in question.
X The X position of this slide item (textbox, image). If not set, defaults to 0. You can use 'right' to place the object next to right edge or 'center' to center the object horizontally. You can use a percentage value to place object for example at 10% of the width of the slide.
Y The Y position of this slide item (textbox, image). If not set, defaults to the bottom of the previous item. You can use 'bottom' to place object at the bottom of the slide or 'center' to center the object vertically. You can use a percentage value to place object for example at 10% of the height of the slide.
Width The width of this slide item (textbox, image). If not set, defaults to 100%. Use either pixels or percentage of slide width.
Height The height of this slide item (textbox, image). If not set, defaults to the font size. Use either pixels or percentage of slide width.
FontSize The font size of this textbox, defaults to 24. Use either pixels or percentage of slide height.
FontFamily/td> The font family of this textbox, default to 'Arial'.
Color The text color. You can use both CSS names (e.g. yellow, lightblue) or CSS/HTML # syntax, e.g. #00ff00.
BackgroundColor The background color. You can use both CSS names (e.g. yellow, lightblue) or CSS/HTML # syntax, e.g. #00ff00.
FirstLineIndent Sets the first line indent of a text box. Use either pixels or percent of width.
PaddingLeft Sets the amount of space between text and left edge of box.
PaddingRight Sets the amount of space between text and right edge of box.
PaddingTop Sets the amount of space between text and top edge of box.
PaddingBottom Sets the amount of space between text and bottom edge of box.
MarginLeft If the Width is in percent, removes this amount from the width. If the Width is in pixels, moves the element to the right.
MarginRight If the Width is in percent, removes this amount from the width. If the Width is in pixels, moves the element to the left. If you place an element at the right edge with X=right, then you can move it, for example, 50 pixels to the left with MarginRight=50.
MarginTop If the Height is in percent, removes this amount from the height. If the Height is in pixels, moves the element downwards.
MarginBottom If the Height is in percent, removes this amount from the height. If the Height is in pixels, moves the element upwards. If you place an element at the bottom edge with Y=bottom, then you can move it, for example, 50 pixels to the upwards with MarginBottom=50. Setting this also moves the next item in the slide, it will be placed MarginBottom pixels lower.

Sample

Here is a sample spreadsheet, creating a two slide presentation with two text boxes.

Item Content
Presentation Title of my new Presentation
TextBox My first textbox
BackgroundColor lightyellow
Width 200
Height 200
X center
Y center
 
Slide
TextBox My second textbox
BackgroundColor lightgreen
Width 200
Height 200
X right
Y bottom

 

 

 

Docs365
Awesome authoring!