This is the Zap I am working onReceive a daily inventory report on gmail in the form of a CSV Use Utilities to pull all the columns from the report Clear rows in the spreadsheet before add ing the new infomation All is working except its not pulling all the columns I need. Attached is the report headers I need the following columns to pull from the reportSKU Name On Hand On Order In Transition Zap InputHere is the default Zap Output When I try change this it just reverts back, and only gives these options for mapping - please help

Utilities not pulling all columns from CSV

This is the Zap I am working on

Receive a daily inventory report on gmail in the form of a CSV
Use Utilities to pull all the columns from the report
Clear rows in the spreadsheet before add ing the new infomation
All is working except its not pulling all the columns I need.
Attached is the report headers
I need the following columns to pull from the report

SKU

Name

On Hand

On Order

In Transition

Zap Input

Here is the default Zap Output

When I try change this it just reverts back, and only gives these options for mapping - please help

Page 1 / 1

Hi @N.Spear

Try using this Zap action: Files by Zapier - Line Items from CSV

https://zapier.com/apps/files-by-zapier/integrations#triggers-and-actions

https://zapier.com/apps/files-by-zapier/integrations#help

Hi @N.Spear!

How did you get on with that Line Items from CSV action Troy suggested? Did it work out better than using the Import CSV File Formatter action you were using previously?

Let us know how it’s going, want to make sure everything’s all set here!

Hi Sam

It clears the sheet but doesn’t put the information into the sheet - what am I doing wrong?

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded