Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.upflow.io/llms.txt

Use this file to discover all available pages before exploring further.

Your customer-facing teams operate on a tool not connected to your organization? Upload their freshest changes so your Upflow information is always up to date. ❗Your customers’ details can only be updated with this method if your organization is not connected to a solution overwriting their information. They can be imported into Upflow depending on your source system.
Your source systemDetailsContactsAccount managers
Native integration
API*
Salesforce + native integration
Salesforce + API*
*assuming your API setup allows it.

File

Start with creating a compliant spreadsheet with the information you want to update: assigned Workflow or Account manager(s) (i.e., assigned users), contacts who receive your reminders, details relevant to your teammates. 💡 Mandatory and accepted fields are listed below. Save it as a CSV file. You can apply ”;” (semicolons), ”,” (commas) and ”|” (vertical bars) separators.

Import process

Click Add customers in the top-right corner of your Customers tab and select the Import or Assign customers option. Add customers button in the Customers tab If not applicable, it is replaced with an Assign customers button. The process remains the same. Assign customers button alternative Column mapping screen during CSV import Map your file’s columns with the matching Upflow Customer fields. Mandatory fields are marked as Required. Submit the document and wait for the completion of the import. You can be notified in-app, via email and/or Slack, per your Profile configuration. Import history button Check your Import history (accessible from the same button) to review the latest updates (timestamp and uploaded spreadsheet). Those marked as erroneous detail why some elements weren’t updated to help you fix the file.
Error messageFix
Account manager not found; check the email.Create a member associated with the uploaded email address.

Columns

Add the following columns to your spreadsheet: their values will populate Upflow fields. Mandatory fields are 🚩 flagged!

Details

Create one line per customer, with their details as columns.
ColumnsDetails
🚩 Customer nameIdentifies this account on Upflow (list, details, analytics…)
Customer IDYour customer external ID (the ID they have in your billing tool), which you can check from their customer page under the Details section.
Accounting code
VAT number
Address
Postal code
Town
State/Region
Country

Groups and entities

If your customers are grouped or have subsidiaries, create additional columns and populate them on the child companies’ lines, indicating the relationship. Spreadsheet columns showing parent/child customer relationships
Columns
🚩 Parent name
🚩 Parent ID

Assignment

To assign an Account manager or a Workflow via file upload, add the following columns to your customers’ list. Spreadsheet columns for assigning account managers and workflows 💡 If you are maintaining your customers and contacts via integration and solely resort to this feature to import your assigned account managers and/or workflows, no need to add the customers’ details.
ColumnsDetails
🚩 External IDThe ID of the customer on your source system.
Account managerEmail address associated to an existing member of your organization with an Account manager role. 💡 Separate emails with a comma to assign several account managers.
Workflow*Name of the workflow assigned to your customer as displayed on your organization.

CSV assignment - Case sensitive

When assigning workflows or users to your customers via CSV, ensure:
  • the workflow name is the exact same in your CSV file: this is case-sensitive, and also applies to symbols. Copy the full workflow name in Upflow and paste it in your file.
  • the user’s email address contains no capital letters, and is the exact same as in your Users list view. Ensure the user is created first, then copy their email address and paste it in the CSV file.

Custom fields

It is also possible to import customer custom field data using a CSV file. Requirements for custom fields:
  • The custom field must already exist in Upflow
  • Only Upflow-managed custom fields can be imported via CSV
    • Synced custom fields from your source of truth can’t be updated by CSV, and must be managed from your system
To include custom fields:
  1. Add a column with the exact name of your custom field
  2. Format the values according to the custom field type (see formatting guide below)
CSV import file Formatting guide
Custom field typeFormatExample
TextPlain text (max 2,000 characters)“Premium customer”
NumberUse period (.) for decimals. Commas not supported. Negative values and decimals are supported.”1234.56”
DateYYYY-MM-DD format only”2025-12-31”
Single-SelectText value that exactly matches an existing option in Upflow. New values cannot be created via CSV.Active
Multi-SelectMultiple values separated by commas or semicolons. All values must already exist in Upflow.”Tag1,Tag2,Tag3”
Booleantrue or false (case insensitive)True, FALSE

Contacts

Create additional columns to update your customers’ contact information. Duplicate the lines of accounts with multiple contacts (you only need to copy and paste the customers’ ID and/or name).
ColumnsDetails
🚩 Customer name
🚩 Client ID (External ID)Your customer’s ID in your accounting tool.
🚩 Contact email address
First name
Family name
Phone number
PositionUsable when defining your reminders’ recipients. Choose between Accounting, Sales, Purchaser, or Payer.
Main contactAdd a “1” in this column on the contact’s line to designate it as your main contact. You can only have one main contact per customer. The latest update overwrites your existing configuration.