tweet project

Annulleret Opslået 5 år siden Betalt ved levering
Annulleret Betalt ved levering

Monitor "Twitter - New Arrivals Tweets" Category in [login to view URL]

For any new product that gets added to this Category add it to the tweet queue in a Google Spreadsheet. The way it should work is it should check the new arrivals category first and get one add it to the sheet then it should check the "Twitter Product Spotlight" category and get one add it to the sheet. Then go back to the New Arrivals category and get another and add it to the sheet then to Twitter Product Spotlight and continue doing this until both Categories have been gone through this way it does not stack all new ones up then go to Twitter Product Spotlight it will mix them.

Each Product has an "product_id=5877" + "Twitter - New Arrivals Tweets" these should be logged in a db or something as we have already tweeted about that new product just in case the product gets readded again. then remove it from the category in [login to view URL] It should only ever be retweeted one time as a new product.

When a new product is detected it will be added to a Google Spreadsheet with date created, category name product id, vendor id, vendor name, product name, product link

Tweets should only go out once every three hours. Starting at 7 AM EST and stopping at 10 PM EST.

It should pull from the Google Spreadsheet from the bottom and add new tweets from the new arrivals category to the top of the sheet.

Each time it tweets it should delete the row from the sheet.

Each time it tweets it should copy all the row data from the queue sheet and copy it to a log sheet with a a couple new cols for date / time tweeted (in Eastern Time) and if it was successful. If not successful put error message.

I would like to start the tweet with "New Arrival from [Vendor Name] - [Product Name]" I would also like to add if there are enough characters left in the tweet based on the URL and content to add three hashtags in order if there is enough room only for one add this one #fishing if room for two add this one next #fishinglife if room for the third add this one next #tacklestore

That is the first part of the process.

This is the second:

The second part is to do the same process but on another category. On this category "Twitter - Product Spotlight Tweets" I want to pick up the product get the information

Write it to the same queue sheet as above then remove it from the category in [login to view URL]

These products can be tweeted over and over again. So there is no need to store in the db or something that they have been done. Cause I will continue add readd products to this category so they are tweeted out when I need them to be.

This tweet will also ignore that they were tweeted from the New Arrivals category.

These will be added to the same New Arrivals queue to go out every three hours. These do not go out in addition to the new arrival ones they are in the same line not in parallel. So there will be one master queue being tweeted and two processes adding to it ie New Arrivals and Twitter Product Spotlight

Each time it tweets it should delete the row from the sheet.

Each time it tweets it should copy all the row data from the queue sheet and copy it to a log sheet with a a couple new cols for date / time tweeted (in Eastern Time) and if it was successful. If not successful put error message.

I would like to start the tweet with "Product Spotlight from [Vendor Name] - [Product Name]" I would also like to add if there are enough characters left in the tweet based on the URL and content to add three hashtags in order if there is enough room only for one add this one #fishing if room for two add this one next #fishinglife if room for the third add this one next #tacklestore

Excel JavaScript MySQL PHP Software Arkitektur

Projekt ID: #16954070

Om projektet

9 bud Remote projekt Aktiv 5 år siden

Tildelt til:

$260 USD in 4 dage
(16 bedømmelser)
6.4

9 freelancere byder i gennemsnit $127 timen for dette job

itsmejainh

Hi, I have read two process and business logic of Twitter and interaction with google spreadsheet and interaction with DB in first part. I have couple of questions though which we can discuss over chat or voice confer Flere

$250 USD in 7 dage
(10 bedømmelser)
4.8
anwarali143222

Hey My name is Anwar Ali l. I will do your work. As i am new in freelancer but i am expert in what i do since 1 years ago so give me a change to prove my skill Thank you Anwar Ali

$88 USD in 2 dage
(1 bedømmelse)
1.0
goundannessen

Free and ready to work hard to make your project successful, don't be afraid to give a youngster a job - u will be positively surprise and astonish.

$55 USD in 3 dage
(0 bedømmelser)
0.0
Aniketsinh23

Interest In Your Project. I Like Too work with You. hire me if you fine best productive and Best work.

$66 USD in 3 dage
(0 bedømmelser)
0.0
somebizzer7

Hi I am looking for a new project and I am interested to work on your project.I use to work in different organisations and I can complete your project on time. So if you are interested please contact me or send me Flere

$55 USD på 1 dag
(0 bedømmelser)
0.0
ArshadAhmad77

A proposal has not yet been provided

$61 USD in 3 dage
(0 bedømmelser)
0.0
kapiltripathioct

A proposal has not yet been provided

$30 USD in 10 dage
(0 bedømmelser)
0.0