Hub Planner and Smartsheet Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Connect Hub Planner and Smartsheet to automate project management workflows. Trigger events from one app, run actions in the other and use AI to make smart decisions. Integrate apps in 3 simple steps - no code required.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Hub Planner and Smartsheet
Detailed info you need to know about Hub Planner and Smartsheet integrations in WEXTL. Explore which modules apps support and how you connect them.
Hub Planner

Resource planning for projects, bookings, time entries, vacations and people.[5]
Smartsheet

Work management for sheets, rows, workspaces, reports, and users.[6]
How to connect Hub Planner to Smartsheet
Set up your Hub Planner and Smartsheet integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Hub Planner and Smartsheet
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected Hub Planner and Smartsheet nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Hub Planner and Smartsheet. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Hub Planner and Smartsheet work in WEXTL?
WEXTL exposes actions and triggers for Hub Planner and Smartsheet that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Hub Planner triggersSmartsheet actions
Hub Planner modules
- Add a Tag to a Project Applies an existing Tag to a project in Hub Planner and returns the updated project with its Status.
- Add a Tag to a Resource Applies an existing Tag to a person and returns that resource with their Role and Status.
- Add an Approver to a Resource Group Adds more Approvers to a resource group in Hub Planner. The group keeps its current approvers.
- Add an Approver to Resource Groups Makes a single Approver responsible for several Groups in one call, instead of editing each group in turn.
- Add Choices to a Project Custom Field Appends new Choices to a project custom field template. Existing options stay in the list.
- Add Choices to a Resource Custom Field Adds extra Choices onto a resource custom field template while keeping the options it has.
- Add Clients to a Project Attaches Clients from your Hub Planner client list to a project.
- Add Projects to a Project Group Files several Projects under one project group in a single call, so they are organised together in Hub Planner.
- Add Resources to a Project Assigns several Resources to a Hub Planner project in one call.
- Add Resources to a Resource Group Files several Resources under one resource group in a single call, which keeps the people you plan together in one place.
- Create a Billing Rate Stores an hourly Rate in a Currency under a Label, ready to be used on billing. The ID of the new rate is output.
- Create a Booking Schedules a Resource on a Project from Start to End. Set Booking Type and Amount to control how the time is measured, and turn on Repeat for a recurring booking.
- Create a Booking Category Defines a category that bookings can be filed under. Use Grid Color to colour it on the schedule grid, and Group to place it in a category group.
- Create a Client Registers a client under its Name. Use Metadata to keep extra data of your own with that client.
- Create a Holiday Records a day off on a Date. Turn on Repeat Every Year for a holiday that returns annually.
- Create a Milestone Sets a dated marker on a Project, labelled with a Name, to flag a key point in the schedule.
- Create a Project Starts a project named Name. Add a Project Code, Status or Note, or switch on Use Project Duration to give it Start and End dates and a Budget Hours figure.
- Create a Project Cost Category Defines a category that project costs can be sorted into, labelled with a Name. Its ID is output.
- Create a Project Custom Field Defines an extra property for projects by Type and Label. Fill Choices for a list field and Instructions for help text, or set Required to enforce it.
- Create a Project Group Creates a group for projects. Use Parent Group to nest it inside another group, which needs the Sidebar Pro extension.
- Create a Project Tag Makes a label for projects from a Value and files it under a Category.
- Create a Resource Adds a person who can be scheduled, from a First Name. Fill Last Name, Email, Role and Status, or use Send Invite Email to invite them to Hub Planner.
- Create a Resource Custom Field Defines an extra property for people by Type and Label. Use Default Value to prefill it and People Can Edit to let resources change it themselves.
- Create a Resource Tag Makes a label for people from a Value and files it under a Category.
- Create a Time Entry Logs the Minutes a Resource worked on a Project on a Date. Add a Note to say what was done.
- Create a Vacation Books leave for a Resource from Start to End. Use Percent Allocation for part days and Approver to name who signs it off.
- Create an Event Adds an event type to Hub Planner from a Name. Use Background Color to colour it and Metadata for your own data.
- Create an Unassigned Work Item Adds a piece of work with no owner yet, described by its Value.
- Create Multiple Projects Creates many projects in one request from the Projects list. Every project made is returned as a separate item.
- Create Multiple Resources Creates many people in one request from the Resources list. Every person made is returned as a separate item.
- Delete a Billing Rate Deletes a stored hourly billing rate. The deleted ID is output.
- Delete a Booking Deletes a booking that had placed a resource on a project. The ID of the deleted booking is returned.
- Delete a Client Removes one client from Hub Planner. Its ID is the result.
- Delete a Holiday Removes a holiday from the calendar. Its ID is returned.
- Delete a Milestone Deletes a dated project milestone and gives its ID as the result.
- Delete a Project Removes a single project from Hub Planner, with its ID as the result.
- Delete a Project Cost Category Removes a project cost category, then returns the ID that was deleted.
- Delete a Project Custom Field Deletes a project custom field template. Its ID is returned.
- Delete a Project Group Removes a project group and returns its ID.
- Delete a Project Tag Removes a label from the list of project tags.
- Delete a Resource Removes a person from Hub Planner and returns their ID.
- Delete a Resource Custom Field Deletes a resource custom field template. The ID that was removed is output.
- Delete a Resource Tag Removes a label from the list of resource tags. Its ID is returned.
- Delete a Time Entry Removes one logged time entry from a timesheet and returns its ID.
- Delete a Vacation Removes a leave entry from the schedule and returns its ID.
- Delete an Event Deletes an event type from the Hub Planner calendar. Its ID is returned.
- Delete an Unassigned Work Item Deletes an unassigned work item. This cannot be undone, and its ID is returned.
- Delete Multiple Bookings Deletes many bookings in one call, selected either by Booking IDs or by every booking of a Resource or a Project.
- Delete Multiple Projects Deletes the chosen Projects together in one request.
- Delete Multiple Resources Removes the chosen Resources together in one request.
Smartsheet modules
- Add a Column Inserts a new column into a sheet. Use Column to set its Title, Type, Format or Index, which decides where it sits among the existing columns.
- Add a Row Inserts rows into a sheet. Use Rows to give each new row a Value for every Column ID. Returns the new Row number and Parent ID.
- Add a Sheet Attachment Attaches a link or file to a sheet by its Name and URL. Use Attachment Type to say whether it is a file or link, Attachment Sub Type for the format, and Description for a note.
- Add an Alternate Email Adds a secondary email address to one Smartsheet user. The user comes from List Users. Returns Message and Result code.
- Attach New Sheet Attachment Uploads a new version of an attachment that is already on a sheet or row. The new file is read from Name and URL. Use Attachment Type for its kind.
- Copy a Sheet Duplicates a sheet into a folder or workspace. Use Destination Type and Destination ID to place the copy, New Sheet Name to title it and Include to bring along parts of the original.
- Copy a Workspace Duplicates a whole workspace. Use Workspace New Name to title the copy. The new workspace arrives with its ID, Name and Permalink.
- Copy Rows Copies rows onto the bottom of a second sheet, keeping the originals in place. The output pairs each source row with its copy under Row mappings.
- Create a Discussion Starts a discussion thread on a sheet with the Comment as its first message. Add a File to attach a document to the thread.
- Create a Group Creates a group in your organization account. Group names must be unique across the organization. Use Description for its purpose and Members to add people right away.
- Create a Proof Generates a proof for a row of a sheet out of an uploaded File. Returns the Proof request URL and Document type of the new proof.
- Create a Proof Request Emails people a request to review a proof. Add the recipients under Send To and write the email as Subject and Message. Turn on Is Downloadable to allow downloads. Turn on CC Me to get a copy yourself.
- Create a Report Builds a Smartsheet report that pulls rows from several sheets. Use Columns to decide what it shows, Destination to place it, and Is Summary Report to make it a sheet summary. Returns the Permalink.
- Create a Sheet in Folder Makes a new sheet inside a folder. Start it with Columns, each with a Title and Type, or copy the layout of a Template ID. The output includes the Permalink.
- Create a Sheet in Workspace Puts a sheet straight into a workspace. Columns lay out its structure, or Template ID copies an existing one. Output includes the ID and Name of the new sheet.
- Create a User Adds a person to your organization account from their Email, First Name and Last Name. Use Status to set their state and Admin to make them a system admin who manages user accounts.
- Create a Workspace Creates a new Smartsheet workspace. Names are limited to 50 characters. Returns its Permalink.
- Delete a Column Deletes a column, located by Column ID.
- Delete a Discussion Removes a discussion thread, found with Discussion ID.
- Delete a Group Deletes a group from the organization, identified by its Group ID.
- Delete a Proof Deletes a proof, taking the Proof ID and its Sheet ID.
- Delete a Report Removes a report from Smartsheet. Sheets that feed the report are not touched.
- Delete a Row Deletes rows of a sheet with no way to undo it. Row IDs come from Get a Row.
- Delete a Sheet Deletes a whole sheet from Smartsheet.
- Delete a Workspace Removes a workspace from your Smartsheet account.
- Delete All Attachment Versions Removes every version of one attachment on a sheet.
- Delete an Alternate Email Removes a secondary email address from a user.
- Delete an Attachment Detaches a document or URL from a sheet.
- Delete an Automation Rule Clears one automation rule from a sheet, using Sheet ID and Automation Rule ID.
- Export a Sheet Downloads a sheet in whichever Format you need and returns it as File Data. Add Paper Size when exporting a PDF.
- Get a Column Fetches the definition of one column, including its Format and Index. Use Level to change how object values such as multi-contact cells appear in text and number columns.
- Get a Contact Reads one saved contact. Returns the Email and a Confirmed flag.
- Get a Discussion Fetches a discussion with its Title, Comments and Comment count.
- Get a Group Retrieves an organization group with its Name, Description, Owner and Members.
- Get a Proof Fetches a proof from a sheet. Use Include with a comma-separated list such as Attachments or Discussions to add those parts.
- Get a Report Reads one report. Trim optional parts of the output through Include and Exclude, or allow COMMENTER access with Access API Level.
- Get a Row Returns a single row of a sheet: its Row number, Parent ID and Cells.
- Get a Sheet Reads the structure of a sheet, including its Columns, Attachments, Discussions and Owner ID.
- Get a User Reads one user of the organization, with their Email, Seat type and whether they are an Admin.
- Get a Workspace Fetches one workspace with its Name, Permalink, creation and modification times, and your Access level.
- Get an Alternate Email Looks up one secondary address of a user. Returns its ID and Email, plus a Confirmed flag.
- Get an Attachment Creates a temporary download link for an attachment. Output has the URL and the URL expires in millis value, so fetch the file before it lapses.
- Get an Automation Rule Reads an automation rule on a sheet along with the values of its Action. Output also says whether the rule is Enabled and gives its Name.
- Get the Current User Shows the account behind the credential, with its Email, First name and whether it is an Admin.
- List Attachments Lists every attachment on a sheet, including those on rows and discussions. Cap the results with Limit.
- List Automation Rules Shows which automation rules a sheet has. Add a Limit for a shorter list.
- List Columns Returns each column of a sheet. Use Level to control how object values are formatted, and Limit to trim the list.
- List Contacts Lists the contacts saved in your Smartsheet account. Use Limit to stop the list at a chosen count.
- List Discussions Gets all discussions on a sheet. Use Include to add optional parts to each discussion.
- List Groups Finds the groups in your organization. Use Modified Since to keep only groups changed on or after a date and time, and Limit to stop the search early.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Hub Planner and Smartsheet integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Hub Planner and Smartsheet.
References
List of sources used to gather information about the Hub Planner and Smartsheet integration.
- Hub Planner and Smartsheet integration source code, module specs and credentials implementation.
- Our Hub Planner and Smartsheet integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Hub Planner and Smartsheet, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Hub Planner integration information
- Smartsheet integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Hub Planner and Smartsheet integration page documentation. Used sources, the role of AI, and how the team validates the result.