Test Google Forms

Test Successful!

Review the response below.
We'll use this as a sample for setting up the rest of your Zap.

gsx$firstname:

svmath

updated:

2018-05-24T21:05:34.847Z

content:

email: svmath@gmail.com, firstname: svmath, lastname: tutor

gsx$email:

svmath@gmail.com

id:

cre1l

gsx$lastname:

tutor

**

Test Google Forms

THINGS TO DOUBLE-CHECK:

•  Make sure you have at least one recent response created.
•  Make sure it matches the trigger options you picked below:

Spreadsheet

Sample Contact List

Worksheet

Sheet1

**

Test Google Forms

Test Successful!

Alright got it! You can view your response to make sure everything looks OK.
We'll use this as a sample for setting up the rest of your Zap.

**

Test Google Forms

Test Successful!

Review the response below.
We'll use this as a sample for setting up the rest of your Zap.

gsx$firstname:

svmath

updated:

2018-05-24T21:05:34.847Z

content:

email: svmath@gmail.com, firstname: svmath, lastname: tutor

gsx$email:

svmath@gmail.com

id:

cre1l

gsx$lastname:

tutor

**

Google Sheets Action

SEARCH

Lookup Spreadsheet Row

Finds a row by a column and value. Returns the entire row if one is found. Optionally, create one if none are found.

**

Search for Google Sheets Spreadsheet Row

NEW!

Sneak Peek Your Setup

Toggle on/off what the data you’re setting up looks like as you set up the template.

 Learn More

Setup Preview

Learn more

Spreadsheet 

Worksheet 

You must have column headers. See here for more information.

Lookup Column 

Let us know which column you want to search by with the value below. We will grab the first matching row and give you all of its values.

Lookup Value 

Create Google Sheets Spreadsheet Row if it doesn't exist yet?

**

Populating Your Template

In this step, you’re deciding what info will be included in the Google Sheets Spreadsheet Row your Zap creates. To pull info from previous steps (like your Google Forms Response), use the + button. This will give you fields to choose from previous steps.

In this example, the Summary of the Google Calendar Event beingcreated will be the Name of the Trello Card that triggered the zap.

You can also type your own information into these fields. If you dothis, what you type will be a part of every Spreadsheet Row your Zap creates.

**

Test Google Sheets

To test Google Sheets, we need to search for a spreadsheet row. This is what we will search for:

Spreadsheet

Sample Contact List

Worksheet

MySheetRL

Lookup Column

Email

Lookup Value

svmath@gmail.com

Skip Test & Continue

**

Test Google Sheets

Test Successful!

Review the spreadsheet row below.
We'll use this as a sample for setting up the rest of your Zap.

COL$B:

tutor

COL$C:

svmath@gmail.com

id:

4

COL$A:

svmath

row:

4

**

Google Slides Action

CREATE

Create Presentation From Template

Creates a new presentation based on an existing one and can replace any placeholder variables found in your template presentation, like {{name}}, {{email}}, etc.

**

Set up Google Slides Presentation

Setup Preview

Learn more

Selected Google Slides fields below contain placeholders that are no longer available.

Show details

Title of New Presentation 

The name of the presentation that will be created.

Quote Proposal

Is Shared? 

If yes, the new presentation will be viewable by anyone who has the link to it.

no

Template Presentation 

Select an existing presentation. (Do not use a "Custom Value" here.)

If that presentation contains placeholder variables like {{name}} or {{email}}, they will show up as fields below.

To use images, create a text box in your template presentation that contains a variable. (e.g. {{company_logo}}) Then below, enter an image URL that starts with http:// or https:// and links to a PNG, JPEG or GIF.

Extra Fields

Heads up! We noticed some extra fields in your Zap that don't seem to be used. This could be caused by changing custom fields or temporary outages. You can clear them out if you suspect they are causing problems!

Template Fields Name

1Gsx$Yourname

**





**