Sheet2Slide is a tool to create a slide deck from data in a Google spreadsheet. Follow these steps to set up and use Sheet2Slide:
- Create a Spreadsheet:
- Populate your Google Sheet with the data that you want to include in your slides.
- Create a Slide Deck:
- Set up a Google Slides deck with one slide that will act as your template.
-
Access Google App Scripts:
- In your Google Sheet, go to Extensions > Apps Script.
-
Add the Script:
- Insert the provided script into the Apps Script editor.
- Configure Script with MASTER_DECK_ID:
- Find the
MASTER_DECK_IDfor your slide deck and add it to the script.
- Find the
- Add a Button to the Spreadsheet:
- Insert a drawing or an image in your Google Sheet to use as a button.
- Assign the Script to the Button:
- Click on the drawing or image, select Assign Script, and enter the function name to link the button with the script.
You should now be able to create slides from your Google Sheet data with the click of a button.
If you encounter any issues, please reach out for assistance.
- Automate Slide Creation: Quickly generate a complete slide deck from spreadsheet data.
- Customizable Templates: Use a custom slide as a template for uniformity.
- Easy Integration: Simple setup process with Google App Scripts.