In this article, we are going to see how to use Google Sheet or CSV with TexAu Recipes.
Let’s consider that you have a Google Sheet with the following columns:
- FirstName
- LastName
- CompanyName
- LinkedIn Profile URL
And, you want to use all the columns in your Recipe.
Step 1: Create local variables for each column in your CSV or Google Sheet
- The first thing that we need to do is to create local variables for each column in your CSV or Google Sheet.
- It’s not mandatory to name the local variables the same as your column names but keeping it the same will help you to easily remember the columns.
- Don’t write any value for these local variables.
- We will use these variables to map the columns of our CSV or Google sheet.
Step 2: Map the local variables in your Recipe.
- Wherever you want to use the column data, simply map the local variables we have created.
- These variables will be later replaced by the actual column data while processing the Recipe.
- So let’s go ahead and map the FirstName and Last Name columns in “Find A LinkedIn Profile” Spice in our Recipe.
- Make sure to map local variables wherever you want to use your columns — in any Spice you are using.
Step 3: Run your Recipe with Google Sheet or CSV
- Now that we have mapped the local variables in all the Spices we have used.
- It’s time to run the Recipe using CSV or Google Sheet.
- All the local variables that you have used in your Recipe must be mapped properly with each column name in this step. Failing to do so will start showing errors while processing.
Let’s see how to use the Google Sheet or CSV with Recipes.
- Click on the CSV / Google Sheet button, next to the “Variables” button.
- Select CSV or Google Sheet
- Map the columns for each local variables you have used in your Recipe.
- Once done, click “Submit Google Sheet” or “Submit CSV”.
It will start running your Recipe.
For Google Sheet 👇🏻
FOR CSV 👇🏻
That’s all!
I hope this helpful 🙂
In case if you still have any questions, feel free to write to us using the chat ↘ available.