Profile cover photo
Profile photo
Elizabeth Voss
86 followers
86 followers
About
Posts

I would like to be able to generate a pre-filled Google Form with information from a Google Sheet or an Excel spreadsheet.

This past year, I sent out membership verification emails to organization members from inside of our database (NationBuilder). NB gave me specific tag names to put into Google Forms so that I could generate a pre-filled form. This worked fine, great even!

However, we found that we had a higher response rate to emails sent from outside of our database system. A colleague was able to use my same pre-filled link and pull information from an Excel sheet and send the emails via Thunderbird.

I would like to be able to handle this process myself, using my Gmail account and existing tools on hand (either a Chromebook or a Windows laptop). My data is currently in Google Sheets, but could obviously be converted to an Excel sheet quite easily.

I just don't have the know-how to make this work.

Any assistance would be greatly appreciated.

Post has attachment

Post has attachment

Post has attachment

Post has attachment

Post has attachment
A visit to the Chinese Garden and various tram rides around the city.
Chickity China, the Chinese Garden
Chickity China, the Chinese Garden
anamericaninbasel.wordpress.com
Add a comment...

Post has attachment
On Friday, Zurich presented its best defense and tried to win me over.  The results were mixed.
Giving Zurich a Chance...
Giving Zurich a Chance...
anamericaninbasel.wordpress.com
Add a comment...

Post has attachment
Our trip wasn't all sunshine and rainbows. Our first day in Zurich made me want to be back in Peoria more than I ever have in my life.
Onward to Zurich
Onward to Zurich
anamericaninbasel.wordpress.com
Add a comment...

Post has attachment
A Brief Walking Tour of Basel
A Brief Walking Tour of Basel
anamericaninbasel.wordpress.com
Add a comment...

Post has attachment
Wait while more posts are being loaded