Bjorn's Deck Factory
Swiftly create new presentations
- a Google Sheets extension -
Sorry, this app has been decommissioned.
A Google Sheets™ add-on.
Use Google Sheets™ to quickly create new Google Slides presentations.
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.
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 |
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. |
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. |
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 |
Check out this short YouTube video.
Note - if you have installed the add-on and the add-on submenu only contains the 'Help' option - PLEASE RELOAD THE DOCUMENT - and the other options will appear.
Please report bugs here or reach out 2 me with questions @ support@backlund.org.
Follow me at Instagram @bjornsplayground and check out more videos at my YouTube channel.
You can view our privacy policy here.