Find Jobs
Hire Freelancers

Gravity Forms - Code an automation: Send mapped entries daily in Excel to specific e-mail

€30-250 EUR

Teljesítve
Kiadva ekkor: körülbelül 5 évvel ezelőtt

€30-250 EUR

Teljesítéskor fizetve
Current situation: We use Gravity Forms + "Gravity Forms Entries in Excel" Plugin The plugin generates an excel file and a link to download the excel file. We download every day the new leads and have to map it into a new order. Current Workflow: 1. Download Excel – See [login to view URL] 2. Delete all old leads 3. Map everything into special format – [login to view URL] 4. Copy special columns in new rows + add some Columns (RecordTypeId, AffiliateID_c) – [login to view URL] 5. Send the result Excel file to a special e-mail address What we want from you: Create an automated workflow to send the new(!) collected leads from gravity forms entries every morning to the mail address with the attachment of the data results. What we think will work: Create an CronJob file which will be called from our server every morning. The file/Cronjob downloads the Excel file from the link, manipulates it to the final result sheet and sends it to the mail address. Maybe you create a small wordpress plugin where we can edit our wished fields (see below). These changes might also be made in the cronjob files header directly, so that no plugin is needed. But please feel free to come up with your solution. What must be configurable? - Documentation if other fields come in addition to it - Excel Download link must be customizable – Maybe unnecessary if you download the gravity form entries directly - E-Mail Address to send to and BCC + CC mail addresses - Field RecordTypeId (J) must be editable - Field AffiliateID_c (I) must be editable
Projektazonosító: 18692043

A projektről

14 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
Hi, I think it can be done this way: create Gravity Forms (GF) addon plugin, which will get latest day entries from database directly (wtihout intermediate excel file) using GF API calls. Then, plugin will append and change collected data so new columns can be added and column titles can be renamed and sends email with attachment in excel format. Not sure what you meant with "Field RecordTypeId (J) must be editable - Field AffiliateID_c (I) must be editable" - all fields will be editable in resulting excel file. Some general info about me below. Please check my ratings and feedbacks to see the proof of my experience and expertise in Wordpress. There are more than 150 of excellent reviews rated 5 out of 5 with 99% completion rate, that is rare case when all employers were fully satisfied! That means I always seek for perfection, please compare to other freelancers with their average rating of 4.8/4.9 and ~80% completion rate. I have successfully completed hundreds of different WP projects starting from minor theme or content updates to huge and complex WP plugin development and dozens of external API integration tasks. I have 11 years experience in Web Development, 6 years with Wordpress. Comparing to other freelancers who are often spamming with their bids I am actually reading your project description and bid with precision only on projects I like. I am located in Latvia, North Europe and I work mostly with employers located in Europe and North America.
€250 EUR 5 napon belül
5,0 (168 értékelés)
7,6
7,6
14 szabadúszó adott átlagosan €175 EUR összegű árajánlatot erre a munkára
Felhasználó avatár
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
€250 EUR 4 napon belül
4,9 (481 értékelés)
8,4
8,4
Felhasználó avatár
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks . .
€155 EUR 3 napon belül
4,8 (78 értékelés)
7,6
7,6
Felhasználó avatár
We can develop an automated form, where you can add new fields, send individual results for each new contact, download all the data collected by the form, in a file in excel We can converse to enter more details and see a demo with your requirements
€100 EUR 5 napon belül
4,9 (46 értékelés)
5,5
5,5
Felhasználó avatár
Hi Sir, I see you need some scripts in the Wordpress and Excel to automate your daily Tasks. I have expertise in Excel and Google Sheets. I was trying to understand the data flow and also saw the attachments. But couldn't understand completely. I need you for the details in this matter. For me, let me assure you that automated emails are possible in Excel and google sheets. Automated data fetch is possible and manipulation too. It's all the matter of securities and programming. Let's discuss this task. I need little detail about the data flow. I believe i can do it.
€250 EUR 5 napon belül
5,0 (10 értékelés)
4,9
4,9
Felhasználó avatár
Hi, i am Wordpress plugin developer. I have 4.9 years of experience. I have completed approximately 28 plugins with complex functionalities. I have read your requirements and will do this task perfectly and within time. I have worked with gravity form so i will easily do this task easily. I will fetch all records of day and create file with that records and send to particular email address with attachment of created file. I will use cron job to perform this action daily. I will provide you all required settings in admin side like cc email, bcc email, main email, cron time schedule, file custom column name etc. I have some questions regarding the functionality so let’s start the discussion and develop the awesome plugin with this functionality. Thanks for consideration.
€166 EUR 5 napon belül
4,9 (11 értékelés)
4,4
4,4
Felhasználó avatár
better opportunity for the better life.i am a dedication and good mannered person. i am happy to say i am available in any time to work as possible as i.
€155 EUR 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
This can be done via robotics process automation. I can design and develop a process automation robot to automate your excel download and update, then send email workflow. You won't need to hire someone to do the task manually. Just run the robot and done... Hire me to know more about the details and make your life easier...
€222 EUR 7 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Good day! I am interested to work with you, I am patient, fast-learner and work oriented person, I will do my best to provide quality of work and be precise, I hope to get back to you soon. I will reply ASAP
€155 EUR 3 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

GERMANY zászlója
Braunschweig, Germany
5,0
17
Fizetési mód hitelesítve
Tagság kezdete: szept. 6, 2018

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.