Google Sheets + Trestle
Update Trestle phone validations in new or updated spreadsheet rows in Google Sheets (Team Drive)
Set up this Zap to manage phone validations from a central spreadsheet. For every new or updated phone number in a row in a Google Sheets (Team Drive) , the Trestle phone validation API will automatically validate the phone number and provide phone metadata, such as carrier name, line type (landline, mobile, non-fixed VoIP, etc.), prepaid status, etc.
Set up this Zap to manage phone validations from a central spreadsheet. For every new or updated phone number in a row in a Google Sheets (Team Drive) , the Trestle phone validation API will automatically validate the phone number and provide phone metadata, such as carrier name, line type (landline, mobile, non-fixed VoIP, etc.), prepaid status, etc.
- When this happens...New or Updated Spreadsheet Row (Team Drive)
Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
- automatically do this...Phone Validation
Validates a phone number and provides phone metadata, such as carrier name, line type (landline, mobile, non-fixed VoIP, etc.), is the phone prepaid, etc.
- then do this!Update Spreadsheet Row
Update a row in a specific spreadsheet with optional formatting.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItDrive
Try ItDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItDrive
SpreadsheetRequired
Try ItDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
