Google Sheets + Teamgate integrations
Create Google Sheets rows for newly won deals in Teamgate
Collecting all the data about won deals in Google Sheets? Save the time it takes to copy the data and prepare the report. This integration will create a row in a selected Google Sheets spreadsheet with the details about every newly won deal in Teamgate CRM.
- When this happens...

New Won DealTriggers when a deal is won.TriggerPolling - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Teamgate and Google Sheets
Discover other triggers and actions you can use with Teamgate and Google Sheets
- Creator
- Status
- Source
- Industry
- Owner
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Creator
- Status
- Source
- Industry
- Owner
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New ProductLists the products.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Deal IDRequired
- In Stock?Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Deal Name
- Deal Stage ID
- Deal Price
- Currency ISO
- Owner ID
- Owner Username
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Lead NameRequired
- Company
- Job Title
- Owner
- Collaborators
- Starred
- Status
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Person NameRequired
- Company
- Job Title
- Owner
- Collaborators
- Starred
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- NameRequired
- Sku
- Description
- Category
- In stock?
- Unit cost value
- Unit cost currency
- Unit price value
- Unit price currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Stage
- Buyer (Company)
- Buyer (Person)
- Name
- Owner
- Collaborators
- Estimated Closure Date
- Price
- Currency ISO
- Is Starred?
- Status
- Source
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Person Name
- Company
- Job Title
- Owner
- Collaborators
- Starred
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Title
ActionThis is an event a Zap performs.SearchFind existing data in your app- Person Name
- Phone Number
- E-Mail Address
ActionThis is an event a Zap performs.SearchFind existing data in your app- TitleRequired
- Phone Number
- E-Mail Address
- Person
- Job Title
- Owner
- Collaborators
- Company Code
- Company VAT Code
- Starred
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
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- Lead NameRequired
- Phone Number
- E-Mail Address
- Company
- Job Title
- Owner
- Collaborators
- Starred
- Status
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
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
- Sku
- Description
- Category
- In stock?
- Unit cost value
- Unit cost currency
- Unit price value
- Unit price currency
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- Dont_change_sheet_structure
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 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.Search or writeFind existing data in your app, or create a new record if no data is found
Email OpenedTriggers when email is opened.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.- TypeRequired
- Responsible
- Company
- Person
- Lead
- Deal Id
- Client Id
- Type
- Before
- Start
- Status
- Is Secret?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- TitleRequired
- Person
- Job Title
- Owner
- Collaborators
- Company Code
- Company VAT Code
- Starred
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- StageRequired
- Buyer (Company)
- Buyer (Person)
- Name
- Owner
- Collaborators
- Estimated Closure Date
- Price
- Currency ISO
- Is Starred?
- Status
- Source
- Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- ContentRequired
- Company
- Person
- Lead
- Deal Id
- Client Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Name
- Sku
- Description
- Category
- In stock?
- Unit cost value
- Unit cost currency
- Unit price value
- Unit price currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Title
- Person
- Job Title
- Owner
- Collaborators
- Company Code
- Company VAT Code
- Starred
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- IdRequired
- Lead Name
- Company
- Job Title
- Owner
- Collaborators
- Starred
- Status
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Title
- Phone Number
- E-Mail Address
ActionThis is an event a Zap performs.SearchFind existing data in your app- Lead Name
- Phone Number
- E-Mail Address
ActionThis is an event a Zap performs.SearchFind existing data in your app- NameRequired
- Sku
ActionThis is an event a Zap performs.SearchFind existing data in your app- Name
- StageRequired
- Buyer (Company)
- Buyer (Person)
- Owner
- Collaborators
- Estimated Closure Date
- Price
- Currency ISO
- Is Starred?
- Status
- Source
- Tags
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- Person NameRequired
- Phone Number
- E-Mail Address
- Company
- Job Title
- Owner
- Collaborators
- Starred
- Industry
- Source
- Phone Number
- Phone Type
- E-Mail Address
- E-Mail Type
- Tags
- Website
- LinkedIn
- Facebook
- Twitter
- Skype
- Street
- City
- Zip Code
- State
- Country ISO Code
- Latitude
- Longitude
- Type
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- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_change_sheet_structure
- No_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.- Drive
- 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 app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- 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
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related categories







