There are many methods in Salesforce to create records, like creating them manually, using a data loader to upload many records at once, or using an apex class. But what if there was a way where a person could just email with data of records to his Salesforce org and records will be created automatically?

Well, this is possible with Salesforce Email Services!

In Salesforce, Email Service can be configured easily and then with some code, you can do basically anything in your org.

So, in this blog today, we will share how to create bulk records in Salesforce with an email.

For this, we will be creating Lead records with Email service and if any Lead is not created the user will be notified which Lead is not created and the cause of the error.

So let’s start the demo!

Step 1:

First, navigate to Setup > Email Services and you will be greeted with this screen:

image1

The above prompt is suggesting you create an apex class that is using this line of code

Code

And you should exactly do what it says and make an apex class with this code to start with.

Step 2:

After making that class you can now click on “New Email Service” and create a new email service(Obviously!).

image2

Step 3:

Give a name to your Email Service, select the apex you created, and fill in other fields as per your requirement.

For this demo, we are receiving a CSV to create records so we will be selecting “All” in Accept Attachments and Convert Text Attachments to Binary Attachments.

Now we have created our email service but still want an email address to which we can send emails to create records. For that, just click on the email service that you just created and select “New Email Address” and an email will be created for you.

image3

And that’s all you have to set up your Email Service.

Step 4:

All that is left to do is write the code for it. For that open the Apex class you created and make the following changes:

Apex Code:

In the above code, I am also using a CSV Reader class “SimpleCsvReader” that you can copy from here:

SimpleCsvReader:

Code

Step 5:

For testing the Email service we will be using this CSV file with Lead Records to insert them:

image4

In this, we left a required field empty to get the error message in return.

When we send this CSV as an attachment in an email to the email address we got from the email service it creates those records in the Lead object.

image5

All the Leads got created except for the one without the company field and for that, we received a CSV in our email showing us the error:

image6

User Testing:

If you want to test this implementation you can send your Lead record CSV in the fields in the above respective order to this email:

leademailgeneration@h-22bywfmax7f6x6qu97pjee6j3mt19x3rizfvq4ane0sdy1bi5p.2w-qutegeaj.ap16.apex.salesforce.com

Conclusion

In conclusion, Salesforce Email Services provide a simple and efficient way to create records in Salesforce by just sending an email with the required data. By setting up an email service and creating an apex class to handle incoming emails, we can easily create records in bulk with the data provided in the email.

Additionally, we can plan to notify the user if any records were not created and provide the cause of the error. This method can save a lot of time and effort, especially when dealing with large amounts of data.

Like the blog? Share your valuable feedback with us and stay connected for more such interesting Salesforce development services!

Related Articles
Expert Guide on Seamless Integration of Salesforce and QuickBooks Online

Integrating Salesforce with QuickBooks Online can significantly streamline your business operations, improving data accuracy and efficiency. QB Sync Made Easy offers a seamless solution to synchronize customer and financial data between the two platforms. This expert QuickBooks Online, on the other hand, is a leading accounting tool specifically developed for small and medium-sized businesses that […]

Read More
A Complete Guide to Salesforce CPQ Contract Amendment and Renewal

Salesforce CPQ software offers robust features for managing pricing, product configurations, and quotations. The capacity to effectively modify and renew contracts is essential for businesses managing intricate agreements and long-term partnerships. In this guide, we’ll walk you through the details of contract amendment and renewal processes in Salesforce CPQ. About Salesforce CPQ Contract Amendments Modifications […]

Read More
Step by Step Guide to Configure Email to Salesforce 1 1

In this detailed guide, we will walk you through the significant yet easy steps to configure Email to Salesforce. Without any further ado, let’s get started! About Email to Salesforce As the term refers, Email to Salesforce is valuable for any organization that businesses use as their Customer Relationship Management (CRM) platform. It helps streamline […]

Read More
Guide on CRUD Operations in Node.js with jsForce

CRM developers typically need to integrate Salesforce with Node.js apps. One well-known library for this purpose is jsForce, which provides a comprehensive set of tools for interacting with Salesforce data and performing CRUD tasks effectively. Let’s dive into the blog, where you will understand the use of jsForce to execute key CRUD tasks within Salesforce, […]

Read More
How to Implement Round Robin Assignments in Salesforce Using Apex

Ensuring a proper workload balance and quick follow-ups from internal or external team members, leads, opportunities, or task distributions is crucial. To achieve this, all you need is a Round Robin assignment. In this step-by-step guide, we will walk you through the process of implementing a round-robin assignment in Salesforce using Apex. Here, we’ve used […]

Read More
Best Salesforce Developments Services Provider

In this step-by-step guide, we will walk you through the significant role of Large Data Volumes in Salesforce, and what strategies or practices you should keep in mind. What is Large Data Volumes? In Salesforce, Large Data Volumes (LDV) refers to managing a huge amount of records available in the platform. LDV usually comes into […]

Read More
Our Location worldwide
Indian Flag India
3rd Floor, A-10, Pegasus Tower, Sector 68, Noida, Uttar Pradesh 201301 +91-1203117884
United States of America Flag USA
333 West Brown Deer Road Unit G – 366 Milwaukee WI, USA 53217 +1(262) 310-7818
United Kingdom Flag UK
7 Bell Yard, London, WC2A 2JR +44 20 3239 9428
Canada Canada
HIC Global Solutions INC
43 Lafferty Lane, Richmond Hill, L4C 3N8, CA +1(262) 310-7818