I am unable to find Caspio column names that match my Gmail attachment

Hi @Harpreet 

Good question.

Please post detailed screenshots with how your Zap steps are configured in order for us to have more context, thanks.

1. 

   

   

   In this step I am not able to map.

This is my error

@Harpreet 

I’d recommend using the Zap Editor instead of the Zap Wizard.

You can edit your Zap here: https://zapier.com/app/zaps

If I use Zap editor, then also I am unable to map and having these option avaiable to map

@Harpreet 

You can use the ‘CUSTOM’ option to map variables between Zap steps.

If you are not seeing a desired field from Caspio, then that’s likely an issue with how Caspio is configured.

OK, I am able to see caspio options but unable to see the gmail attachment columns which is an excel sheet

@Harpreet 

This is the variable to use.

NOTE: Must be SINGULAR for “Attachment”

so, I am getting file name as my result, not the values in the table.

Hi @Harpreet!

I wanted to check in to see if you still needed help here. I did some tinkering and I figured out a way to get the column names from an attached Excel file. It takes a few steps in your Zap, but it can be done :)

Here’s the gist:

Trigger: New Attachment in Gmail
Action: Upload to Google Drive
Action: Formatter — Utilities — Import CSV
Action: Formatter — Text — Split Text (get the header row)
Action: Formatter — Text — Split Text (get the column names)
Action: Wherever you want to use the column names

If what I’ve laid out above isn’t clear, please let me know!

NOTE: what I added in the Gmail step was to show an example of using a search string to only capture the attachments you want. You’d have to decide what to use there :)