Add new applications submitted in Good Grants to Google Sheets as spreadsheet rows
When new applications are submitted in Good Grants, automatically add the data as new rows in Google Sheets spreadsheets.
When new applications are submitted in Good Grants, automatically add the data as new rows in Google Sheets spreadsheets.
- When this happens...Application Submitted
Triggers when a new application is submitted.
TriggerInstantThis event starts a Zap instantly. - automatically do this!Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
NameRequired
Action Task TokenRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Allocation SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Application SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Application SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Assignment slugRequired
NameRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Payment SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
User SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Action StageRequired
ApplicationRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Score SetRequired
ApplicationsRequired
ReviewersRequired
RoundsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Slug
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TokenRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SlugRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.List Fields
Returns a list of fields.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SlugRequired
TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First Name
Last Name
Temporary Access Code
Email
Mobile
Role
User Fields
SlugRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Application SlugRequired
Field SlugRequired
NameRequired
DataRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SlugRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
NameRequired
Action Task TokenRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Application Slug
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Application SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Application SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Payment SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
Payment SlugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.NameRequired
User slugRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Chapter
CategoryRequired
SeasonRequired
Form
ApplicantRequired
TitleRequired
Status
Moderation Status
Application Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
Temporary Access CodeRequired
EmailRequired
Mobile
Roles
User Fields
Preferences
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SlugRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Slug
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EmailRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TagRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Category
Chapter
Applicant
Title
Status
Moderation Status
Application Fields
SlugRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Application SlugRequired
Tab SlugRequired
NameRequired
OrderRequired
DataRequired
Attachment Fields
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SlugRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appReviewerRequired
Score Set
SlugRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNo Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found