How to Automate CSV Data Import in Salesforce with Skyvia

How to Automate CSV Data Import in Salesforce with Skyvia


Learn how to automate CSV data import in Salesforce with no coding. Skyvia is a no-code cloud data platform that supports both Salesforce standard and custom objects and requires nothing except a web browser. In this example we will show how to import leads into Salesforce from SFTP and set up scheduling options.

Get Skyvia for free: https://skyvia.com

Timestamps:

00:00 - Introduction
00:41 - Create SFTP and Salesforce connections
01:17 - Create an import task and set up mapping
02:50 - Schedule the integration
02:59 - Visual ETL data pipeline designer

πŸ‘‰ Do you want to learn more about Skyvia? Watch our overview video: https://www.youtube.com/watch?v=41JIlV1bP9c

βœ… Check how Skyvia products can help your company in different scenarios: https://skyvia.com/solutions/

πŸ”₯ Solve a wide range of data related tasks with our all-in-one cloud data platform! Get started for free https://app.skyvia.com/register

πŸ”” Subscribe to our channel and get dozens of Skyvia tutorials and useful videos: /@skyvia3342

πŸ“§ Do you have any questions or tutorial-related ideas? Feel free to leave a comment or send us an email to sales@skyvia.com
Closed Caption:

Hello, and welcome to Skyvia tutorials. In today's video, we will check how to import leads from a CSV
file to Salesforce with the help of Skyvia. This tutorial assumes you already have a Skyvia account
and Salesforce and SFTP connections. If you don't have a Skyvia account yet, you can create it for
free by following the link in the description.
You can import CSV files to Salesforce either
from your local computer or the online storage service. With Skyvia you can connect to different
storages and for this example, we chose SFTP as it is a secure protocol widely used for data transfer.
Let's start with selecting Import from the menu, and defining Source and Target. Choose CSV from
storage service and select SFTP connection as Source, and Salesforce connection as Target.
To
define where and what exactly to do with CSV data, add an import task. Each Import consists of one
or more import tasks that allow you to combine different operations with the same or multiple
objects inside one integration. While importing CSV data, you can choose a new CSV file for each import
task and later decide which files to include by selecting only the tasks you need.
To create an
import task click β€œadd new”, select the path to your file and optionally configure the CSV settings.
Here you can tune Separators, Text Qualifiers, Delimiters, Locale and Page Encoding to your
specific needs. If you do not need any additional tuning - just leave it in the default state and click
Next Step.
On the Target Definition page select Salesforce object to work with. In our case it is
lead. Then select the operation you want to perform.Β 
It can be either insert, update, upsert or delete.
As we are up to inserting data into Salesforce, we choose Insert. You may read more about each
operation in details by following the link in the description. After choosing the operation, click
"next step".
You will see the CSV file columns displayed on the left and the Salesforce lead
fields displayed on the right. Fields required for mapping are marked with a red asterisk. Skyvia tries to map all the fields automatically. However, you can map fields manually as you
see fit. There are four mapping types available: Column, Constant, Expression, and Lookup.
Let's use the expression to concatenate the First and Last name columns and map the result to the Full Name
field.
Once the mapping is done, click apply and
save. Now you can run Import integration manually or based on schedule, monitor the Import execution,
and check logs. Click Run to Launch it or click on Schedule to define the integration schedule.
Let's
schedule the integration to run every week on Monday at 8 AM Stockholm time, starting
now.
For those who like building ETL pipelines, Skyvia created data flows. It allows you to create
complex scenarios with multiple data sources and apply additional transformations. Let's
check the same import we've done created with it. Here we get data from a CSV file, Extend
it with a FullName field with the Extend component and insert it into Salesforce in
Target.
Thank you for watching this CSV import tutorial. If you still have
any import-related questions, drop us a comment below and we will help you. To
try Skyvia for free use the link in the description. See you in the next videos.

Video Length: 03:40
Uploaded By: Skyvia
Published: 1/16/2024
View Count: 23,253

Related Software Products
Skyvia Data Integration
Skyvia Data Integration

Published By:
Devart

Description:
Skyvia Data Integration: No-Code ETL, Replication and Sync Between 200+ Cloud Apps and Databases Skyvia Data Integration is Devart's browser-based ETL service that moves data between more than 200 cloud apps, databases, data warehouses and file storages, with import, export, replication and two-way sync wizards and a visual pipeline designer, and no code to write. It's for operations staff, analysts and small data teams who need Salesforce...


Related Videos
Connect SQL Server to Snowflake: Replication & 2-way Sync
Connect SQL Server to Snowflake: Replication & 2-way Sync

Video Length: 10:14
Uploaded By: Skyvia (2/17/2025)
View Count: 5,789

Dynamics 365 Integration with SQL Database or Data Warehouse
Dynamics 365 Integration with SQL Database or Data Warehouse

Video Length: 09:22
Uploaded By: Skyvia (9/20/2024)
View Count: 4,476

Data Integration. Lookup Mapping
Data Integration. Lookup Mapping

Video Length: 10:59
Uploaded By: Skyvia (12/4/2024)
View Count: 321

Skyvia Data Replication
Skyvia Data Replication

Video Length: 05:05
Uploaded By: Skyvia (10/22/2025)
View Count: 205

Copyright Β© 2026, Ivertech. All rights reserved.