Google BigQuery + MiiTel

Create rows in Google BigQuery for new unanswered incoming calls in MiiTel

When an unanswered call comes in on MiiTel, it triggers an automatic process that creates a new row in your Google BigQuery. This efficient workflow ensures that all your important call data is captured, collated, and stored for easy access and analysis. It helps eliminate the need for manual data entry, saving your team valuable time and reducing the risk of potential errors.

When this happens...
Incoming Unanswered
Triggers when unanswered incoming call has registered.
TriggerInstant
automatically do this!
Create Row
Creates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Company ID
- Sequence ID
- Parent sequence ID
- Previous sequence ID
- Call type
- Circuit title
- Call from
- Call to
- Call transferred to
- Dial start time
- Call end time
- Account name
- Contact person name
- URL
Trigger
Instant
Try It
- Company ID
- Sequence ID
- Parent sequence ID
- Previous sequence ID
- Circuit title
- Call from
- Call to
- Dial start time
- IVR pressed time
- DTMF
- Account name
- Contact person name
Trigger
Instant
Try It
- Company ID
- Sequence ID
- Call type
- Circuit title
- Call from
- Call to
- Dial start time
- Call start time
- Call end time
- Call duration
- Account name
- Contact person name
- From login ID
- From user name
- To login ID
- To user name
- URL
- Minutes
Trigger
Instant
Try It
- Company ID
- Sequence ID
- Parent sequence ID
- Previous sequence ID
- Call type
- Circuit title
- Call from
- Call to
- Call transferred to
- Dial start time
- Call start time
- Call end time
- Call duration
- Call memo
- Account name
- Contact person name
- From login ID
- From user name
- To login ID
- To user name
- URL
- Speech recognition
- Speech recognition summary
- Number of silences
- Overall
- Number of overlaps
- Talk:Listen
- Number of rallies
- Amd probability
- Fundamental frequency (Customer)
- Fundamental frequency (Operator)
- Intonation strength (Customer)
- Intonation strength (Operator)
- Customer speech rate
- Operator speech rate
- Neutral keywords customer
- Neutral keywords operator
- Positive keywords customer
- Positive keywords operator
- Negative keywords customer
- Negative keywords operator
Trigger
Instant
Try It
- Company ID
- Meeting ID
- Title
- Start time
- End time
- Last comment entered in
- Comment
- Login ID
- User name
- URL
Trigger
Instant
Try It

- Company ID
- Meeting ID
- Title
- Start time
- End time
- Duration
- Host login ID
- Host user name
- URL
- Minutes
Trigger
Instant
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Polling
Try It

- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write

- Company ID
- Sequence ID
- Call type
- Circuit title
- Call from
- Call to
- Last comment entered in
- Comment
- Account name
- Contact person name
- Login ID
- User name
- URL
Trigger
Instant
Try It
- Company ID
- Sequence ID
- Call type
- Circuit title
- Call from
- Call to
- Call memo
- Account name
- Contact person name
- Login ID
- User name
- URL
Trigger
Instant
Try It
- Company ID
- Sequence ID
- Parent sequence ID
- Previous sequence ID
- Call type
- Circuit title
- Call from
- Call to
- Call transferred to
- Dial start time
- Call end time
- Account name
- Contact person name
- Login ID
- User name
Trigger
Instant
Try It
- Company ID
- Meeting ID
- Title
- Meeting type
- Duration
- Start time
- End time
- Call memo
- Host login ID
- Host user name
- URL
- Speech recognition
- Neutral keywords customer
- Neutral keywords user
- Positive keywords customer
- Positive keywords user
- Negative keywords customer
- Negative keywords user
Trigger
Instant
Try It
- Company ID
- Meeting ID
- Title
- Start time
- End time
- Call memo
- Login ID
- User name
- URL
Trigger
Instant
Try It
- ProjectRequired
- Dataset
- Table
Trigger
Polling
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Polling
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn more

Related categories

About MiiTel

MiiTel is an AI-powered IP phone. With MiiTel, you will be to accomplish the following: "Increase your sales", "Achieve self-coaching", and "Can make calls from home".

Learn more