Google Tables + SQL Server + ezidox Integrations

How to connect Google Tables + SQL Server + ezidox

Zapier lets you send info between Google Tables, SQL Server, and ezidox automatically—no code required.

When this happens...

automatically do this...

then do this!

Free 14-day trial

5,000+ supported apps

Do even more with Google Tables + SQL Server + ezidox

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Google Tables, SQL Server, and ezidox. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

- WorkspaceRequired
- TableRequired
Trigger
Scheduled
Try It
- WorkspaceRequired
- TableRequired
- ViewRequired
Trigger
Scheduled
Try It
- WorkspaceRequired
- TableRequired
- RowRequired
Action
Write
- WorkspaceRequired
- TableRequired
Action
Search
- Table/ViewRequired
Trigger
Scheduled
Try It

- QueryRequired
  Query results must have a unique id field so we can deduplicate records properly! Otherwise we will make a best guess. You must also include desired ordering and limiting in the query.
  Note: This query must run in less than 30 seconds and it is recommended that you return no more than 5,000 rows
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
  Usually something auto-incremented like id. Must be unique. Column names that contain a space must be enclosed within brackets [ ].
- Order ByRequired
  Usually something like date_updated or last_modified. This should ideally be a datetime column that is set to the current datetime whenever a row is updated.
- Trigger Column
  Trigger on changes to cells in this column only. Leave blank if you want to trigger on changes to cells in all columns.
Trigger
Scheduled
Try It

- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
  You should include desired ordering and limiting (usually to 1 record) in the query.
  This query must run in less than ~30 seconds.
Action
Search
Application Status Updated
Triggers when an application status has been updated (not via B2B services).
Trigger
Instant
Try It
Document Not Relevant
Triggers when a document is marked as not relevant.
Trigger
Instant
Try It
Document Uploaded
Triggers when a new document is uploaded.
Trigger
Instant
Try It
- ApplicationRequired
- Uploader User Type
  Edit the application on behalf of a collector or stakeholder.
- Uploader
  The email of the collector editing the application (REQUIRED only in case of userType = COLLECTOR).
- Stakeholder: TypeRequired
  What is the role of the Primary Sender?
- Stakeholder: EmailRequired
- Stakeholder: NameRequired
- Stakeholder: SurnameRequired
- Stakeholder: Mobile NumberRequired
  Insert a mobile number with international prefix, for example: 61412345678.
- Stakeholder: Is Primary?Required
- Stakeholder: Is Notified?Required
  Select false only if someone else will upload all the documents on behalf of the Primary Stakeholder.
- Stakeholder: Is a Company?Required
- Stakeholder: See Other Sta Docs?Required
  Set to yes to allow the primary stakeholder to see the list of documents of the other stakeholders in the application?
- Stakeholder: Send Default Docs?Required
  Include yes/no the document to be sent to the customer when a new application is created. Currently no OutDocuments are set by default on any template.
- Stakeholder: Company TAX Number
- Stakeholder: Company Name
- Select the Doc Set to Collect
  If you cannot see your document set here, please ensure it is shared at Company Level.
- Stakeholder: Request Def Groups
  Do you want to include all the groups flagged as “Selected by Default?”.
- Stakeholder: Request Def Docs
  Do you want to include all the documents flagged as “Selected by Default?” for all the groups.
Action
Write
- Application Name
- IsDraftRequired
  Is the application in Draft status?
- Collector
- IncludeDefaultCollectors
  Set true to Include DefaultCollectors to the application.
- External Id
  The identifier for the application in an external system.
- Application Reference Number
- Application Days Until Due Date
  Used to set the DueDate parameter on the application (will add DayUntilDueDate to today).
- Application Welcome Message
  Used set the Application Welcome Message. On order or priority the system will use (higher to lower): • Welcome Message defined in the request • Welcome Message associated to the template for each stakeholder.
- Attributes
- Stakeholder: TypeRequired
  What is the role of the Primary Sender?
- Stakeholder: EmailRequired
- Stakeholder: NameRequired
- Stakeholder: SurnameRequired
- Stakeholder: Mobile NumberRequired
  Insert a mobile number with international prefix, for example: 61412345678.
- Stakeholder: Is Notified?Required
  Select false only if someone else will upload all the documents on behalf of the Primary Stakeholder.
- Stakeholder: Is a Company?Required
- Stakeholder: Company TAX Number
- Stakeholder: Company Name
- Stakeholder: See Other Sta Docs?Required
  Set to yes to allow the primary stakeholder to see the list of documents of the other stakeholders in the application?
- Stakeholder: Send Default Docs?Required
  Include yes/no the document to be sent to the customer when a new application is created. Currently no OutDocuments are set by default on any template.
- Select the Doc Set to Collect
  If you cannot see your document set here, please ensure it is shared at Company Level.
- Stakeholder: Request Def Groups
  Do you want to include all the groups flagged as “Selected by Default?”.
- Stakeholder: Request Def Docs
  Do you want to include all the documents flagged as “Selected by Default?” for all the groups.
Action
Write
- ApplicationRequired
- Application DocumentRequired
- CollectorRequired
- Rejection Reason IdRequired
- Rejection Comment
- Send Email
  Set to true if you want to notify all the stakeholders and collectors that this document has been rejected.
Action
Write
- ApplicationRequired
- Uploader User TypeRequired
  Upload the document on behalf of a collector or stakeholder.
- UploaderRequired
  The email of the collector or stakeholder of the document.
- Application DocumentRequired
- Delete Old
  Replace any previously uploaded documents with the new document.
- Description
- DocumentRequired
Action
Write
- Template NameRequired
  Document Template name.
Action
Search

- WorkspaceRequired
- TableRequired
Trigger
Scheduled
Try It
- WorkspaceRequired
- TableRequired
Action
Write
- HTTP MethodRequired
- URLRequired
  Requests can only be made to domains associated by this application.
- Query String Parameters
  These params will be URL-encoded and appended to the URL when making the request.
- Headers
  Authentication headers are included automatically
- Additional Request Headers
  Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
- Body
  Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.
Action
Write
- WorkspaceRequired
- TableRequired
Action
Search or write
- Table/ViewRequired
  We expect at least one unique (and usually autoincrement) primary key column so we can deduplicate records properly! Otherwise we will make a best guess on a random column to use to deduplicate.
- Order By
  Highly recommended! Usually you want the results to be most recent first so we can skim off only new results, so choose something like date_created or your autoincrement id. Column names that contain a space must be enclosed within brackets [ ].
- Dedupe Key
  We default to what the primary key is on the table as the unique key to deduplicate on. If you prefer another field, select it here.
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
Application Created
Triggers when a new application is created.
Trigger
Instant
Try It
Document Accepted
Triggers when a document is accepted.
Trigger
Instant
Try It
Document Rejected
Triggers when a document is rejected.
Trigger
Instant
Try It
- ApplicationRequired
- Application DocumentRequired
- CollectorRequired
Action
Write
- ApplicationRequired
- Application DocumentRequired
- CollectorRequired
- CommentRequired
- IsInternalRequired
  Is the comment internal (not visible to customers)?
- User TypeRequired
Action
Write
- NameRequired
- SurnameRequired
- EmailRequired
  A collector with this email must not already exist.
- Mobile NumberRequired
  Insert a mobile number without prefix, for example: 412345678.
- External Reference
  External system identifier associated to the Collector. Can be used to query the Collector. This identifier is unique and is not visible in the UI.
Action
Write
- ApplicationRequired
- StakeholderRequired
Action
Write
- NameRequired
- From Creation Date
- To Creation Date
- Application Status Category
Action
Search
- Template Set NameRequired
  You can find your Document Template Set at this link: Ezidox.
Action
Search

Top companies trust Zapier to automate work and free up time

Connect your apps and automate workflows

Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.

By signing up, you agree to Zapier's terms of service and privacy policy.

How Google Tables + SQL Server + ezidox Integrations Work

Step 1: Authenticate Google Tables, SQL Server, and ezidox.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Google Tables + SQL Server + ezidox

About Google Tables

Google Tables helps teams easily track & automate tasks, enabling them to save time and work smarter.

Related categories

Databases

About SQL Server

SQL server (or MS SQL) is a top of the line database geared for the cloud

Related categories

Databases

Similar apps

MySQL

Databases

PostgreSQL

Databases

Firebase / Firestore

Databases

About ezidox

Ezidox is a cloud-based platform for automating and simplifying the collection and exchange of documents required for transactions.

Related categories

Documents

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Google Tables + SQL Server + ezidox Integrations

How to connect Google Tables + SQL Server + ezidox

Do even more with Google Tables + SQL Server + ezidox

New or Updated Row

TableRequired

New Row in View

WorkspaceRequired

TableRequired

ViewRequired

Update Row

WorkspaceRequired

TableRequired

RowRequired

Find Row

WorkspaceRequired

TableRequired

New Column

Table/ViewRequired

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

Application Status Updated

Document Not Relevant

Document Uploaded

Add Stakeholder

ApplicationRequired

Uploader User Type

Uploader

Stakeholder: TypeRequired

Stakeholder: EmailRequired

Stakeholder: NameRequired

Stakeholder: SurnameRequired

Stakeholder: Mobile NumberRequired

Stakeholder: Is Primary?Required

Stakeholder: Is Notified?Required

Stakeholder: Is a Company?Required

Stakeholder: See Other Sta Docs?Required

Stakeholder: Send Default Docs?Required

Stakeholder: Company TAX Number

Stakeholder: Company Name

Select the Doc Set to Collect

Stakeholder: Request Def Groups

Stakeholder: Request Def Docs

Create Application

Application Name

IsDraftRequired

Collector

IncludeDefaultCollectors

External Id

Application Reference Number

Application Days Until Due Date

Application Welcome Message

Attributes

Stakeholder: TypeRequired

Stakeholder: EmailRequired

Stakeholder: NameRequired

Stakeholder: SurnameRequired

Stakeholder: Mobile NumberRequired

Stakeholder: Is Notified?Required

Stakeholder: Is a Company?Required

Stakeholder: Company TAX Number

Stakeholder: Company Name

Stakeholder: See Other Sta Docs?Required

Stakeholder: Send Default Docs?Required

Select the Doc Set to Collect

Stakeholder: Request Def Groups

Stakeholder: Request Def Docs

Reject Document

ApplicationRequired

Application DocumentRequired

CollectorRequired