How can I Convert Amazon Order Csv file(In Google Drive) to Zoho book Format Csv File

[Sreejith]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY0MDYzMTA0M2Q1MjY5NTUzNTUxM2Ei_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Dear Pabbly ,

I get Sales report from amazon in Csv format & I add that file in Google drive then Read from Pabbly & that Data I want create a new csv file in Zoho book format

is it possible?
or
How can I Send the Amazon Order Data in to Zoho book .

I created a workflow but I got stucked at time formator in Amazon csv file Date like :31-10-2025 19:37
I don't know this workflow works or not?
please guide me

 

[ArshilAhmad]

Hi @Sreejith,

We have changed the From Format in your Date/Time Formatter, which seems to have fixed your issue.

There is no endpoint in Zoho Books API documentation which allows you to directly upload CSV to Zoho Books.

Introduction | Zoho Books | API Documentation

www.zoho.com

===========================================================================

Pabbly

connect.pabbly.com

The way you have set up your current workflow, it looks like you will upload a new CSV file to your Google Drive each time a new order is created in your Amazon account (different spreadsheets for different orders). You then want to use 'Get Row(s)' action step to fetch the order details and create a new sales invoice in Zoho Books. If this is your use case, then you have set up the workflow correctly. Just make sure you map the Spreadsheet ID in the 'Get Row(s)' action step from your trigger step.