Zapier: Read and get value from excel file.

- I need a freelancer who have knowledge about zapier. The trigger of the zap is when the new file is upload to a specific folder in google drive => Filter: Continue if name of the file contain _Cv.xlsm. => Code: Read the file and get these value (Full name, birthdate, district, phonenumber, email, education type, certificate, facebook, desired salary, desired company). => Airtable: Update these value on airtable.

* Airtable setting:

- “CV” table: update above value to this table

- “Language skill” table: English speaking (A), English speaking (B), …., English writing (A), English speaking (B),… Just like that.

- Foreign language profiency field is link to language skill table.

* Other field like birthday, name,district, etc is simple. Just update the value in airtable. But watch out fot these field.

- 1. Foreign language profiency field: link to “language skill” table

In excel file If English speaking level is A => In proportion to “English speaking (A)”, English writing level is B- => In proportion to “English writing (B-)”.

- 2. Certificate:

This field contain both the certificate value in Foreign language and Certificate and Achievement in excel file (only count if the type is certificate). The column format is multiple select with each certificate is one option.

- [url removed, login to view]

The format is Long text with text format is for example. In excel file, java skill is level S and 6 years experience => Display as java (S/6). The format is like below.

- Java (A/6)

- php(B,5)

- [url removed, login to view]

Column is longtext with text format is

- From – to (value in excel file) : <company name>

- From – to (value in excel file) : <company name>

Because 3 app zap required at least starter plan. So if freelancer need I’ll lend my zapier account.

Znanja: Javascript, Python

Več: 400 error blank rows cannot be written use delete instead, google sheets zapier, zapier update spreadsheet row, zapier create spreadsheet row, excel zapier, zapier excel online, zapier lookup spreadsheet row, bargle. we hit an error creating a spreadsheet row. :-( error: 'values', php excel file load database update insert data, read selected excel file vb6, read existing excel file cnet, read write excel file, read form excel file visual basic, read data excel file using winapi, read data excel file insert mysql using aspnet, read modify excel file using php script, read write excel file visual basic, vbscript search value excel file, upload read save excel file database, asp vbscript read update excel file

O delodajalcu:
( 2 mnenja ) Ho Chi Minh, Vietnam

ID projekta: #15802861

3 freelancerjev ponuja v povprečju za ₫650000 na tem delu


How are you, hoatt?. Do you need a freelancer who have knowledge about zapier ?.I sure i can help you We have experience in thoses skills: Javascript, Python. **Why you should choose me to d Več

₫1000000 VND v 4 dneh
(8 Ocen)

Hello. I’ve carefully gone through your job post. I have more 8+ years experience in Web development .I am very much interested in your project with all of your requirements. I feel very confident on your project Več

₫550000 VND v 1 dnevu
(7 Ocen)

A proposal has not yet been provided

₫400000 VND v 5 dneh
(0 Ocen)