Skip to content

The Idea Village Automates Google Sheets to Slides with Slideform

Transforming content from a spreadsheet into hundreds of branded one-pagers is a big task. Marketing and event-managers often spend valuable hours copying over data and adjusting layouts manually.

By automating the Google Sheets to Google Slides workflow, organizations not only save a tremendous amount of time, but also improve accuracy and consistency across marketing content -- boosting client satisfaction and standing out in a competitive market. Read on to see how event organizers use Slideform to create personalized marketing collateral at scale.

idea_village_logo_alison

The Idea Village

Location: Louisiana, USA

Industry: Economic Development

Company Size: < 10 employees

 

The Idea Village is a startup accelerator based in New Orleans, LA. They host events where they need to produce numerous brochures and profiles of the companies and entrepreneurs in their program. The company profile includes logos, detailed product descriptions, and information on company founders and their fundraising ask.

To create company profiles, the event organizers collect details in a Google spreadsheet via a simple online form. With Slideform, they can connect Google Sheets directly to Google Slides to generate dozens of investor profiles with a single click. The final slides can then be shared with event attendees and investors, or they can be printed for those who prefer a hard copy brochure.

"We use Slideform to create the company/founder one-pagers for our annual 3rd Coast Venture Summit. They were eventually put into a book that was distributed among investors ... We loved how the final product was a Google Slide presentation - it was very easy to share and monitor access to founders who would/could make final tweaks to their one-pagers."

- Ingeborg, Event Organizer

Challenge:

The team needed a solution to generate hundreds of one-page company profiles in Google Slides. Before finding Slideform, they attempted to write a custom script to take data from Google Sheets into Slides. Slideform's no-code automation tools provided a stress-free alternative to maintaining and updating custom Apps Scripts.

Key Outcomes:

  • Save hundreds of hours on manual formatting and editing
  • Seamlessly pull data from Google Sheets into a customized Google Slides template
  • Generate a copy of a Google Slide for each row in the Google Sheet

Solution:

Slideform provides The Idea Village an intuitive solution to generate custom formatted one-pagers from a spreadsheet. Idea village staff created a template layout for the company profiles in Google Slides. The template included text fields, logo images, and sections with table layout and custom font formatting. Once data on the participating companies are collected in a Google Sheet, the project manager uses Slideform's Bulk Mode to match the spreadsheet columns to the corresponding content fields in the template. Then she can generate a one-pager for each company, or select a specific set of companies with filters. Each one-pager is sent to a shared Google Drive and can be edited, shared, or printed just like any other Google Slide presentation. With Slideform, the event organizers are now free to focus on producing the best event experience for participants.

Slide automation allows The Idea Village to create customized, data-intensive content at scale.

 

What can Slideform do for your team?

Get full access to Slideform with a free trial. No credit card required.

Start today
,