Make text fit into slides (Google Slides)

How To
1

I import data from Airtable into Google Slides.
The text is sometimes too long for the slides, which makes the text appear outslide the slide.

In google Slide you have at least 2 ways to make text fit on the slide; through the format options, and through the theme editor.

When I automate an import to those slides, these rules are overwritten. Is there a way to shrink text on overflow on an automation?

3

I think you should consider ways to limit the length of the text content, instead of fitting it after sending to Google Slides.

2 Likes
4

How about breaking up your text fields into multiple items and make sure you know how much text in terms of characters you can fit in each text box? Then break up your text in Make into strings of maximum size, and then place each string into each text block in the slides. I don’t think there is a way to automate resizing of elements in Make. Maybe there are API calls you can make in Slides to do this but I’m not sure.

3 Likes
5

Thank you for your answers. I hoped to find an automated way to fix that.

As an alternative I was looking for breaking the text in columns (like you have in Word) as on my slide I splitted it manually in 2 columns. This way, if one part of the text is longer, it might compensate with the other part.

But there again I didn’t find a way to have 2 columns that split according to the amount of text. Any suggestions here?

6

Here’s how to split text into roughly equal lengths without breaking up whole words.

Setup

Screenshot_2024-02-15_124740

Your magic formula

Screenshot_2024-02-15_124755

Output

Screenshot_2024-02-15_124809

You can copy and paste this module export into your scenario. This will paste the modules shown in my screenshots above.

  1. Copy the code below by clicking the copy button when you mouseover the top-right of the code block
    Screenshot_2024-01-17_200117

  2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV to paste in the canvas.

  3. Click on each imported module and save it. You may need to remap some variables.

Modules JSON Export

{
    "subflows": [
        {
            "flow": [
                {
                    "id": 49,
                    "module": "util:SetVariable2",
                    "version": 1,
                    "parameters": {},
                    "mapper": {
                        "name": "Split_Text",
                        "scope": "roundtrip",
                        "value": "{{add(emptyarray; join(slice(split(48.value; space); 0; floor(length(split(48.value; space)) / 2)); space); join(slice(split(48.value; space); floor(length(split(48.value; space)) / 2)); space))}}"
                    },
                    "metadata": {
                        "designer": {
                            "x": -1213,
                            "y": -586
                        },
                        "restore": {
                            "expect": {
                                "scope": {
                                    "label": "One cycle"
                                }
                            }
                        },
                        "expect": [
                            {
                                "name": "name",
                                "type": "text",
                                "label": "Variable name",
                                "required": true
                            },
                            {
                                "name": "scope",
                                "type": "select",
                                "label": "Variable lifetime",
                                "required": true,
                                "validate": {
                                    "enum": [
                                        "roundtrip",
                                        "execution"
                                    ]
                                }
                            },
                            {
                                "name": "value",
                                "type": "any",
                                "label": "Variable value"
                            }
                        ],
                        "interface": [
                            {
                                "name": "Split_Text",
                                "label": "Split_Text",
                                "type": "any"
                            }
                        ]
                    }
                }
            ]
        }
    ],
    "metadata": {
        "version": 1
    }
}
3 Likes