Hi Team,
My question is :
From excel sheet i need to fetch order number and search in amazon or flipkart and send an email with the invoice to the customer who purchased it.
Please guide the flow.
Regards,
Shristy
@Anonymous automate
@Anonymous
Herewith, I am sharing you a few steps that you can follow to create your flow, this involves creating custom connector for communicating with API service.
- For getting information from excel you can use pre-available excel connector
- For searching information related to invoice and extraction of details you can use custom connector to get connected to Amazon API services.
(https://docs.microsoft.com/en-us/connectors/custom-connectors/define-blank)
- Once you have the response you can use Parse JSON action to parse the information that you get in the response.
- Finally, you can use Send email action and include all the information required from Parse JSON action and send email.
If this information helps you with resolution, please consider giving a thumbs up and mark the solution as resolved.