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.
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.
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:
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.