Simple add row to google spreadsheet from email
Required skills: PHP, Software Architecture
I would like a script to automatically add a row to an existing google spreadsheet whenever an email is received.
Functionality:
- Email arrives into an existing gmail account (dedicated for this purpose)
- The subject line contains data for the new row, with each column delimited by “~” characters. E.g.
Subject line: “Organise a meeting with Mike~5~URGENT”
The script would then create a new row in the google spreadsheet with the following information:
Column 1 value: “Organise a meeting with Mike”
Column 2 value: “5”
Column 3 value: “URGENT”
- There is a Google Spreadsheets API available with functionality to add rows: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html
- The script needs to be hosted with a free hosting service which you will need to select & configure (search “free php hosting” for a list). I need this hosted this so I can maintain it myself please (i.e. not hosed on your hosting or shared hosting somewhere).
- You will probably need to set the script up as cron job to poll for new emails from the gmail account every minute (unless the free hosting comes with an email address you can take content directly from?)
Other points:
- Basic documentation required please (e.g. account & ssh details for the free hosting, location of the script, etc)
- The script needs to scale if more “~” signs are used (e.g. if there are 5 “~” characters in the subject, 6 values/columns are present)
- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.
- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.
Many thanks
Posted In:PHPSoftware Architecture |
Related projects:
Simple add row to google spreadsheet from email
>
- The script needs to scale if more “~” signs are used (e.g. if there are 5 “~” characters in the subject, 6 values/columns are present)
- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.
- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.
Many thanks
- The script needs to scale if more “~” signs are used (e.g. if there are 5 “~” characters in the subject, 6 values/columns are present)
- Only information in the subject line should be used to create the new row. Any data in the body should be ignored.
- Login details for the gmail account & google spreadsheet will be provided to the successful bidder.
Many thanks
Add Products To Google Shopping.
ll my products already. But I am getting the error that it is:
"Missing Unique Product Identifiers"
And they are not searchable.
I need this fixed ASAP, and I need an automatic feed where my products will always be updated in Google without error. Also, I need the products to be searchable and be complete on the Magento side so there are no issues when feeding into Google.
This is a simple project that requires minor troubleshooting.
"Missing Unique Product Identifiers"
And they are not searchable.
I need this fixed ASAP, and I need an automatic feed where my products will always be updated in Google without error. Also, I need the products to be searchable and be complete on the Magento side so there are no issues when feeding into Google.
This is a simple project that requires minor troubleshooting.
Simple Data Entry To Get Quotes From A Site
The project is a simple data entry to get quotes from a site.
You have to get me around 100 quotes.
Refer the attached file for more info before you bid.
Timeline : 2 days max.
Expertise in this field will be given preference.
Bid only if you are confident and deliver all by 2 days. max.
Budget fixed.
You have to get me around 100 quotes.
Refer the attached file for more info before you bid.
Timeline : 2 days max.
Expertise in this field will be given preference.
Bid only if you are confident and deliver all by 2 days. max.
Budget fixed.
Alternative Google Spreadsheet Ui Using Php
a or delete etc), click on Save button and data will be saved to the spreadsheet
5, A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information, phs.phd at googlemail dot com
5, A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information, phs.phd at googlemail dot com
Google Spreadsheet Email Script
I get information emailed to me from web forms (i.e. name, phone number) that I would like automatically logged into a Google Docs Spreadsheet.
I'm basically looking for a script for Google Spreadsheet that can scan my email account (say every 60 seconds) for new messages - check the message body for information (i.e. name, phone number) - and log the data into the corresponding columns of an ongoing spreadsheet.
I'm basically looking for a script for Google Spreadsheet that can scan my email account (say every 60 seconds) for new messages - check the message body for information (i.e. name, phone number) - and log the data into the corresponding columns of an ongoing spreadsheet.
Need to extract data from email to Google Spreadsheet
tatus: verified
business:
quantity: 1
verify_sign:
txn_id:
payment_type: instant
payer_business_name:
btn_id:
last_name:
payment_fee: 0.89
shipping_discount: 0.00
insurance_amount: 0.00
receiver_id:
txn_type: web_accept
item_name:
discount: 0.00
mc_currency: USD
payment_gross: 15.00
business:
quantity: 1
verify_sign:
txn_id:
payment_type: instant
payer_business_name:
btn_id:
last_name:
payment_fee: 0.89
shipping_discount: 0.00
insurance_amount: 0.00
receiver_id:
txn_type: web_accept
item_name:
discount: 0.00
mc_currency: USD
payment_gross: 15.00
Customized Google Spreadsheet Mapper Project
ust I can purchase a copy of google earth and use that to link to google spreadsheet. In this instance I will still need the Google Spreadsheet Mapper document modified to work with the data from the attached spreadsheet. Once again, Iframe option is desired.
If you're interested in this project please tell me how you would implement what I'm looking for along with your quote. I need this done within the next 24-48ish hours so preference will go to those who respond quickly.
If you're interested in this project please tell me how you would implement what I'm looking for along with your quote. I need this done within the next 24-48ish hours so preference will go to those who respond quickly.
connect to google API and email (needed in 1 day)
(like COKE for Coca-cola, F for Ford, DIS for Disney) and then you have Coca-cola in your portfolio, Ford, Disney in your portfolio and that is all you need. Google will then show you info about your stocks. In particular it will show Symbol Last price Change Mkt cap Volume Open High Low. I just need to access LAST PRICE field for each stock in my portfolio. I don't need to write to the portfolio. I just need to acccess these fields.
Basic data-entry from web to excel spreadsheet by ocass
ample.
Please take a look at the link and the template and reply with a realistic estimate of how long this will take you to complete.
I have budgeted $ 50 for this project, and I need it started ASAP.
LINK:
http://www.civicnet.bc.ca/siteengine/ActivePage.asp?PageID=83
Thank you.
Additional files submitted:
BC_Municipalities_Template.xls
Please take a look at the link and the template and reply with a realistic estimate of how long this will take you to complete.
I have budgeted $ 50 for this project, and I need it started ASAP.
LINK:
http://www.civicnet.bc.ca/siteengine/ActivePage.asp?PageID=83
Thank you.
Additional files submitted:
BC_Municipalities_Template.xls
Add Macros to Excel Spreadsheet / Dashboard
o worksheet data to be created:
a. Current month
b. Week on week variance ie. Current month - Last month (+/-)
c. Last 4 weeks average ie. Curent month + Last 3 months / 4
d. Last 12 weeks average ie. Current month + 11 months / 12
2. Add macro to charts up so they update automatically
Attached is an example of how it works including formulas. I would like this functionality copied on to the Dashboard.
a. Current month
b. Week on week variance ie. Current month - Last month (+/-)
c. Last 4 weeks average ie. Curent month + Last 3 months / 4
d. Last 12 weeks average ie. Current month + 11 months / 12
2. Add macro to charts up so they update automatically
Attached is an example of how it works including formulas. I would like this functionality copied on to the Dashboard.
Simple website with paypal/google checkout
I'm looking for a simple HTML website to be coded from the mockup that I have created. I have all images and text needed for the website, it literally just needs to be coded. Must feature a simple shop layout with cart that can be processed through paypal/google checkout, an image hover code for shop images and a slideshow type image viewer for the front page. Super easy and a quick job for most.
Add products to Google Shopping and Froogle
Would like my products add to Google Shopping and Froogle.
website is http://www.eztankless.com
website is http://www.eztankless.com
Modify/Add features to my Crawler for craigslist
om one email account, they block you for the next 24 hours.) The system should be able to change the 'From' email address in order to avoid this situation.
3. The system should give the ability to scrape only true email addresses (e.g. ) or only craigslist generated email addresses or both
4. System should allow me to review the email list, edit the marketing email content and send
5. System should show the history of sent emails
Thanks
PB.
3. The system should give the ability to scrape only true email addresses (e.g. ) or only craigslist generated email addresses or both
4. System should allow me to review the email list, edit the marketing email content and send
5. System should show the history of sent emails
Thanks
PB.
Add Images To Excel Spreadshee
E" onmouseover="this.style.textDecoration='underline'" onmouseout="this.style.textDecoration='none'">yousendit.com.
Need QUICK turnaround.
PROJECT REQUIREMENTS:
1. Add images to excel spreadsheet, next to appropriate item number on left side
2. Adjust cells to fit contents on page, that is legible and looks professional
3. Cell height should be same as sample spreadsheet (SEE PM)
Please bid on completed project.
Thank you.
Need QUICK turnaround.
PROJECT REQUIREMENTS:
1. Add images to excel spreadsheet, next to appropriate item number on left side
2. Adjust cells to fit contents on page, that is legible and looks professional
3. Cell height should be same as sample spreadsheet (SEE PM)
Please bid on completed project.
Thank you.
add subcategories to JOOMLA
upport this structure
SECTION >> CATEGORY >> ARTICLE
and you can't add any more sub-level categories
what i want is the ability to add subcategory where the subcategory will appear under the parent category in the front end
i also want to be able to add articles to multiple categories from the back end "not very important"
the most important thing is ability to add unlimited subcategories as needed
thank you
SECTION >> CATEGORY >> ARTICLE
and you can't add any more sub-level categories
what i want is the ability to add subcategory where the subcategory will appear under the parent category in the front end
i also want to be able to add articles to multiple categories from the back end "not very important"
the most important thing is ability to add unlimited subcategories as needed
thank you
Add Products To Google Base
I need the entire database of my products on http://www.giftends.com added to Google Base. There are approximately 2500+ products. It would be best to create an excel or xml file first, then upload directly to Google Base. I would also like a copy for the excel or xml file if this is created. You will be using my Google Base account to upload the products.
Alternative Google Spreadsheet Ui Using Php
A page to allow navigation of all data in the table. Default is 100 row per page, and there should be Next and Prev link (like Google search result). The next and Prev link should also be used for search result.
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information.
Tags: [New Feature] PHP, Template, Google, Editing, Data Entry, Vector Graphics, Google Spreadsheet PHP
6, A barcode icon is shown on each row, when click on it, it will generate barcode--optional
You can email me for more information.
Tags: [New Feature] PHP, Template, Google, Editing, Data Entry, Vector Graphics, Google Spreadsheet PHP
Email Scanner W/auto Posting To Google Calendar
n event on my Google calendar, lasting for 15 minutes, titled "X County" (with "X" being the word immediately preceding the word "County" found in that paragraph) at the correct date and time.
I believe the rules I've outlined above should capture all of the events I'm looking for and exclude the ones I don't want (though we'll need to test it once built to make sure it does all the including and excluding correctly). I really don't think this should be a very big project.
I believe the rules I've outlined above should capture all of the events I'm looking for and exclude the ones I don't want (though we'll need to test it once built to make sure it does all the including and excluding correctly). I really don't think this should be a very big project.
Google Spreadsheet Web Ui Using Php
9/6/2010 at 11:06 EST)...
Important:
**Do not say something like this" pay me how much money and I will get it done in xx days"
** List your capabilities is not relevant. I need a demo before I can select you, your demo should be:
###, Search the spreadsheet and display in a tabular format.
###, click view icon to display data in web page
###, click the edit icon and pull data from spreadsheet display in a form, click submit to update a row
Important:
**Do not say something like this" pay me how much money and I will get it done in xx days"
** List your capabilities is not relevant. I need a demo before I can select you, your demo should be:
###, Search the spreadsheet and display in a tabular format.
###, click view icon to display data in web page
###, click the edit icon and pull data from spreadsheet display in a form, click submit to update a row
Webpage improvement & Email migration to Google Apps
Additional files submitted:
Our+Homepage.png
Prefer+site.png
