Double HQ + Smartsheet

Update Smartsheet rows for each client properties update in Double HQ

Stay on top of your client properties with this efficient workflow. Each time there's an update to client properties in your Double HQ app, this workflow ensures that these changes reflect in the Smartsheet app by updating a new row. Say goodbye to manual data entry, as this automation provides an accurate and timely way to monitor changes to your client data. Enhance your data management strategy while saving time and minimizing errors.

When this happens...
Client Properties Update
Triggers when client properties are modified.
TriggerInstant
automatically do this!
Update Row
Update an existing row with new values. Requires a row ID.
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

Client Creation
Triggers when a new client is created.
Trigger
Instant
Try It
Close Status Update
Triggers when the status of a close is modified.
Trigger
Instant
Try It
- Contact EmailRequired
Action
Write
- Client IDRequired
- EmailRequired
- Phone Number
- First NameRequired
- Last Name
- Grant Financial Access
Action
Write
Get Property Columns
Get available properties for your practice in Double.
Action
Write

- Client IDRequired
- Template IDRequired
Action
Write
Update Properties
Update properties for a specific client in Double.
Action
Write

- Client IDRequired
Action
Search
- Choose a SheetRequired
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- SheetRequired
- RowRequired
- File AttachmentRequired
Action
Write
- Choose a SheetRequired
- Add Row to Top or Bottom
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- SheetRequired
- ColumnRequired
- Parent Row
Action
Write
- DestinationRequired
- Sheet to CopyRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Row IDRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- FormatRequired
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a WorkspaceRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet IDRequired
- QueryRequired
Action
Search

Client Properties Update
Triggers when client properties are modified.
Trigger
Instant
Try It
Task Status Update
Triggers when the status of a task is modified.
Trigger
Instant
Try It
- Client nameRequired
- Workflow type
Action
Write
- Client IDRequired
- Template IDRequired
- Should publish?Required
Action
Write
- Client IDRequired
- Task NameRequired
- Due Date
- Priority
Action
Write
Get Templates
Get project templates for your practice in Double.
Action
Write
- Client IDRequired
Action
Search
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a SheetRequired
Trigger
Polling
Try It
- Select a ReportRequired
Trigger
Polling
Try It
- Workspace NameRequired
Action
Write
- Choose a SheetRequired
- RowRequired
- TitleRequired
- CommentRequired
Action
Write
- Source FolderRequired
- Destination FolderRequired
- New Folder NameRequired
Action
Write
- WorkspaceRequired
- New NameRequired
- What to Include?
- Skip Remap
Action
Write
- Choose Source SheetRequired
- Choose a Destination SheetRequired
- Choose RowRequired
Action
Write
- DestinationRequired
- TemplateRequired
- Copy Cells?Required
- Copy Attachments?Required
- Copy Discussions?Required
- Sheet NameRequired
Action
Write
- Choose a SheetRequired
- Email Address(es)Required
- Choose RowRequired
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a SheetRequired
- Email Address(es) to Share ToRequired
- Access LevelRequired
- Notify via Email?Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet IDRequired
- Row IDRequired
Action
Search

About Double HQ

Double HQ is a platform bookkeeping and CAS firms rely on for month-end close and practice management, with live connections to QBO and Xero. Formerly Keeper.

Related categories

Accounting

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

Related categories

Spreadsheets

Double HQ + Smartsheet

Update Smartsheet rows for each client properties update in Double HQ

Client Creation

Close Status Update

Lookup Client by Email

Create Contact

Get Property Columns

Add Template to Client

Update Properties

Get Contacts

New Attachment

New Row

Updated Row

Add Attachment to Row

Add Row to Sheet

Copy Row

Export Column

Create Sheet From Existing Sheet

Update Row

Send Sheet

Share Workspace

Find sheet Row (Legacy)

Find Sheet Row

Client Properties Update

Task Status Update

Create Client

Apply Organizer Template to Client

Create Task

Get Templates

Get Client Properties

Get Reports

New Comment

New or Updated Report Row

Create Workspace

Add Discussion to Row

Copy Folder

Copy Workspace

Move Row

Create Sheet From Template

Send Row

Share Sheet

API Request (Beta)

Find Attachment

About Double HQ

Related categories

About Smartsheet

Related categories

Similar apps

MySQL

Zoho Creator

Knack