How to Use the Redwood Google Form Open House Template

Redwood has provided an Open House form template that agents can use to collect visitor information during Open House events.


Step 1: Setting Up Google Form for Open House

Creating a Copy of the Google Form (First-Time Access):

– Click HERE to create a copy of the C21 Redwood Open House form.

Editing the Form:

The form includes important fields such as name, email, and phone number. You may customize the form by adding or rewording questions, but we recommend not removing any questions, as the information collected will assist in following up with potential clients after the Open House.

To edit a question:

  1. Click on the question box you wish to edit. 
  2. Update the text or add additional responses as needed.
  3. For more assistance with form editing, reach out to your ASM to schedule a meeting.

Finalizing & Presenting the Open House Form:

After completing your edits, you’ll need to gather the form link and create a QR code to add to your Open House 1-Page Brochure in Marketing Studio 2.0.

Steps to gather the form link:

  1. Click the Send button (top right of the form).
  2. Click the link icon (chain symbol) in the pop-up window.
  3. Check the box labeled Shorten URL for a simpler link.
  4. Click Copy to save the link to your clipboard.

Creating a QR Code:

There are many free QR code generators available. If you have a Canva account, you can also create a QR code using that platform. For any questions, contact your ASM.


—


Step 2: Adding the Open House QR Code to the Flyer

  1. Log in to accessRedwood.
  2. Click on Marketing Studio 2.0.
  3. Navigate to Brochures.
  4. Select 1-Page Vertical Brochure w/ QR Code.
  5. Edit the flier’s information (listing address, photo, price, etc.).
  6. To add the Open House QR Code:
  • Select the QR Code space.
  • When the pop-up appears, drop the QR code into the box or click Browse to upload it from your computer.
  1. Once the flier is complete, download the PDF and print it using your personal printer or a Redwood Office Printer.

—


Step 3: View the Responses in a Spreadsheet

  1. Open Your Google Form:
    • Return to Google Forms and open your specific Open House registration form.
  2. Access Responses:
    • Click the Responses tab at the top of the form.
  3. Create a Spreadsheet (First Time Using the Form):
    • Click the Google Sheets icon (green icon in the Responses tab).
    • A prompt will appear: Select Create a New Spreadsheet or Link to an Existing Spreadsheet.
    • Click Create. Google Sheets will automatically generate and open a spreadsheet with the form’s responses.
  4. View and Organize Responses:
    • The spreadsheet will display all form responses in real-time, with each row representing a new submission.
    • You can sort and filter responses based on the fields you added (e.g., name, time slot).
  5. Access the Spreadsheet Anytime:
    • To access the responses later, go to Google Sheets or navigate through your Google Form’s Responses tab, and click the View in Sheets button.

Resources:

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.