Find Jobs
Hire Freelancers

Zapier / Airtable / Email / Smartsheet / Box integration

$250-750 USD

Imefungwa
Imechapishwa about 6 years ago

$250-750 USD

Kulipwa wakati wa kufikishwa
we want to automate some workflows. Workflow 1: custom art request / logging. Parsed from automated email. Note – currently the email may contain more than one order number. 1. Receive an order like below, with multiple rows. 2. Create a single row in smartsheet every time there is a unique new Order No; with Customer Number. a. Bonus points – count the number of rows and add the count to a the file count cell in that row in smartsheet. 3. Check to see if the customer number relates to a folder in my [login to view URL] account. a. If yes, get the shared link for the folder and add it to the row in smartsheet. b. If no, create the folder and add the shared link to the row in smartsheet. 4. Add ALL rows to a. A base in airtable. b. Group by order number. Workflow 2: customer proofing -- When new images with corresponding item codes are added to a folder (the customer’s folder on box, or on an FTP) we want to create an interactive proof approval form. 1. Images added to folder. 2. Zap finds corresponding rows in airtable and adds image(s) to row. 3. Airtable approval form is generated & sent to customer for approval. a. Note – I need to generate an approval form that can be updated in airtable as a subset of a much bigger ‘base’ but which an individual customer can access and log comments / feedback, without having to have a username and password. 4. Approval status / send status is logged in project / smartsheet row matching order number. Workflow 3: proofs approved. 1. Approval status in smartsheet changes to proofs approved. 2. Pdf print files are downloaded to our server. 3. Smartsheet updated to indicate new file status. See attached screenshots. Note -- please be able to demonstrate past experience.
Kitambulisho cha mradi: 16292393

Kuhusu mradi

2 mapendekezo
Mradi wa mbali
Inatumika 6 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
2 wafanyakazi huru wana zabuni kwa wastani $535 USD kwa kazi hii
Picha ya Mtumiaji
Hello Sir, We are team of professional developers We have great experience in we read your project description very care fully and I understand your requirement we need some more information about your project thank you
$515 USD ndani ya siku 10
4.8 (48 hakiki)
6.0
6.0

Kuhusu mteja

Bedera ya UNITED STATES
keene, United States
5.0
13
Njia ya malipo imethibitishwa
Mwanachama tangu Jan 7, 2016

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.