Heello! 

Adding data from Google sheet was one of the most requested feature on TexAu. We knew why this is so important for everyone. Well now we have it, now you add data from different columns and send more personalized messages to users on different platforms.

Let's see a step by step guide on how to do this:

Step 1: Creating a Google Sheet with all the data in it.

  • Create a Google sheet with all the data in it. If you have used any previous you can download that CSV and upload it on Google sheets. I have created this test Google to show a demo with a single row in it. 
  • As you can see I have headers as Profile URL , First Name  , Company  , Job  and Work Description
  • I have added a row just for the demo but you can have 100s of data to send connection request of messages to your targeted users. 

Step 2: Submitting this Google Sheet in Spice

  • Now that our Google sheet is ready, we will go to LinkedIn message sender or Connection request or Facebook Message sender and paste the Google sheet.
  • When you paste the Google sheet, we will automatically fetch the first row and show you the column names or example data, in case if you don't have headers. 

Step 3: Preparing the message

  • Preparing the message is very easy, simply type the message you want to send and wherever you want to add the data from the sheet, simply click on "Insert Tags" and select the column name, it will be added automatically.
  • See the example below.

Step 4: Submitting the Spice for execution

  • Now that we have added all the data, let's submit it for execution and see if this works correctly.
  • I submitted the Spice and see the message I sent to my friend Prem, as you can see in the Google sheet above as well. 
  • You can see the text I had added in my Google sheet 👇

And now,

Here is the message that was sent to Prem on LinkedIn:


That's it! 

So now you know how to send more personalized messages using TexAu.

How we can make the most of this?

Good question!

  • We have Company Info extractor to know about company
  • Profile Scraper to find all the details about the profile

You can more personalized messages when you have more data, for example something like this:

"Hi {{Name}}

I see you that you are working  at {{company}}  as {{Current Position}}  that's great! 

We at TexAu {{TexAu short link}}  are always looking for the best people like you to work with us. I would love to chat with you and see if we can do something together. 🙂

Please schedule a call for us here - {{Meeting link}}  

Looking forward to hearing from you.

Cheers,
Vikesh"

 
Lastly, we will write another article on personalization using Hyperise and Lemlist. You can attach images in the chat and get better attention. Hyperise integration is done, we will create a Recipe and share it with you.

Lemlist is coming next week.

---

Don't forget to give your feedback on this article by using any of these emojis below 👇

Any suggestions, feedback and thoughts on this? Click on the chat icon present on the corner ➡️OR ↘️


Thank you!

Last updated on: 19-Dec-2019 at 9:04:34 AM

Did this answer your question?