Use Google Workspace to create Google Slides

1. In the Lobby, select the Google Suite project that has been done as part of previous tutorials as mentioned in pre-requisites.

2. In Build Process Automation, choose Create and then select Automation.

   

3. In the Create Automation window, enter Google Workspace-Slides as name and An automation to use Google Slides as a description.

   

   You will be navigated to the automation editor of the newly created automation.

1. In the Automation Details panel, under Automations, drag and drop the Google Authorization automation you created.

   

2. You will automate the creation of a new Google presentation in Google Slides. In the Automation Details panel, under Tools, search for the activity Create Presentation (Google Slides) and drag and drop it into the workflow.

   This activity takes an optional parameter for title of document. If not specified untitled document will be created.

3. Select the activity. Under Input Parameters as a title type Automation Presentation and select the expression in quotes.

   

4. You will now add a slide to the presentation you created. In the Automation Details panel, under Tools, search for the activity Add Slide (Google Slides) and drag and drop it into the workflow.

   You will set the parameter for presentationID, the id of the presentation in which you want to add a slide.

   • Select the activity. Under Input Parameters, for presentationId, choose the pencil to open the expression editor.

   • Choose as Variables: presentationDetails>presentationId.

   • Choose Save Expression.

   

5. Now you will add a header to the slide you added. In the Automation Details panel, under Tools, search for the activity Add Slide Header (Google Slides) and drag and drop it into the workflow.

   You will set the parameter for presentationID, the id of the presentation in which you want to add a header.

   • Select the activity. Under Input Parameters, for presentationId, choose the pencil to open the expression editor.

   • Choose as Variables: presentationDetails>presentationId.

   • Choose Save Expression.

   

   Now you will set the parameter for slideId, the id of the slide in which you want to add a header.

   • Under Input Parameters, for slideId, choose the pencil to open the expression editor.

   • Choose as Variables: slideDetails>slideId.

   • Choose Save Expression.

   

6. For text enter the text to be added in the slide header, here: Hello SAP Build Process Automation! and select the expression in quotes.

   

7. Next, you will create a list in the slide you added. In the Automation Details panel, under Tools, search for the activity Create list (Google Slides) and drag and drop it into the workflow.

   You will set the parameter for presentationID, the id of the presentation in which you want to add a list.

   • Select the activity. Under Input Parameters, for presentationId, choose the pencil to open the expression editor.

   • Choose as Variables: presentationDetails>presentationId.

   • Choose Save Expression.

   

   Now you will set the parameter for slideID, the id of the slide in which you want to add a list.

   • Under Input Parameters, for slideId, choose the pencil to open the expression editor.

   • Choose as Variables: slideDetails>slideId.

   • Choose Save Expression.

   

8. For text enter the description of the list, here: Welcome to SAP Build Process Automation, you will learn: and select the expression in quotes.

   

9. For values you will enter the array of values to be added as the list items. Choose the pencil to open the expression editor.

10. In the expression editor enter the following code: ['How to create a presentation', 'How to create a list', 'How to insert images']

11. Choose Save Expression.

    

    You will add a slide to the presentation.

    Please note that an existing slide can be updated. To get the slide id for an existing presentation, you can open the slide in the browser and id can be fetched from the URL.

    Once slide id is obtained, one can use Add Slide, Add Image, Add Text and Add Slide Header etc. activities within a slide to update it. It is also possible to add list and table in the slide.

12. In the Automation Details panel, under Tools, search for the Add Slide (Google Slides) and drag and drop it into the workflow.

    You will set the parameter for presentationID, the id of the presentation in which you want to add a slide.

    • Select the activity. Under Input Parameters, for presentationId, choose the pencil to open the expression editor.

    • Choose as Variables: presentationDetails>presentationId.

    • Choose Save Expression.

    

    You will now add an image in this slide.

13. In the Automation Details panel, under Tools, search for the Add Image (Google Slides) and drag and drop it into the workflow.

    You will set the parameter for presentationID, the id of the presentation in which you want to add an image.

    • Select the activity. Under Input Parameters, for presentationId, choose the pencil to open the expression editor.

    • Choose as Variables: presentationDetails>presentationId.

    • Choose Save Expression.

    

    Now you will set the parameter for slideID, the id of the slide in which you want to add an image.

    • Under Input Parameters, for slideId, choose the pencil to open the expression editor.

    • Choose as Variables: slideDetails>slideId.

    CAUTION: Please select the slideDetails of step 6 of your automation (the slide you just added)

    • Choose Save Expression.
    

14. Finally you will insert the image. For link you will insert the link of the image to be added in the slide.

    Link: https://logos-download.com/wp-content/uploads/2016/08/SAP_logo.png

    CAUTION: The URL should start with http:// or https://. The image must be less than 50MB in size, cannot exceed 25 megapixels and must be in PNG, JPEG or GIF format.

    

    You will now retrieve the details of your Google Presentation and log them in a message.

15. In the Automation Details panel, under Tools, search for the activity Get Presentation Details (Google Slides) and drag and drop it into the workflow.

    You will set the parameter for presentationID, the id of the presentation for which you want to get the details.

    • Select the activity. Under Input Parameters, for presentationId, choose the pencil to open the expression editor.

    • Choose as Variables: presentationDetails>presentationId.

    • Choose Save Expression.

    

16. In the Automation Details panel, under Tools, search for the Log Message and drag and drop it into the workflow.

17. Select the activity. For message parameter, select result to log the details of the presentation.

    Finally you will disconnect the Google Account.

18. In the Automation Details panel, under Tools, search for the Disconnect (Google) and drag and drop it into the workflow.

19. Save the automation.

    

You will now test your automation.

1. Choose Test.

2. Fill in the Environment Variables:

   • For userEmail: your Gmail user email
   • For serviceAccountKeyPath: the full path to the json file
   

3. Choose Test.

   

   The testing was successful. You may see the details of the presentation in the test console.

4. You may go to your Google Slides and you will see that a presentation called Automation Presentation was successfully created.

   

5. After opening it, you will see that two slides were successfully created in the presentation. The first with a header and a list, the other with the image.

   

The entire project is available in the SAP Build Store as a sample and you can follow the below steps to retrieve the project and use it for reference.

To retrieve this sample, please follow these steps:

1. From the SAP Build Lobby, navigate to Store.

2. Search for the sample project: How to use Google Workspace.

3. Choose Add > Create from Template to retrieve the sample and save it as a new project in your lobby.

   

4. Choose Create.

   

   Your project gets created in editable version. You may release and deploy it and run the project.

5. Navigate back to the lobby by clicking on the SAP logo.

   

   You can see your project is available in the lobby.