The work is describes as follows:
A Google Form is used for all creative requests on the website. Need the following:
1. Script for the Google Form that does the following, once submitted:
a) takes the info in the form, and populates it on a corresponding Google spreadsheet
b) takes any assets that were uploaded to the form, creates a folder on our Google Drive with the name of the project and puts all the assets in there. It then creates a link to the google drive folder and puts that URL into one of the columns of the spreadsheet
c) sends emails to specified roles of everything in the request form as a confirmation
2. Set up zaps on Zapier that pulls all of the info from the Google Spreadsheet and:
a) populates a new request on the Creative Requests Board in [login to view URL] with all the necessary info and URL links to both the google drive URL for the assets and an actual URL for the item (to be used later).
b) populates a new item on a private board called High Level Overview that is used to monitor overall progress. This board is a very basic board that lists all active projects, who is the lead, what is the status, due date and items’ URL from the bullet above to enable ease of review. It is also has links to the project drafts and final and is updated with the status of the design work (see below).
c) Creates a shareable board (includes clients) and populates with the info in the request board but has two columns linked to a Dropbox account one for drafts and the other for the final assets. There is also a status column for each item to be marked New Draft or Final which automatically updates the related High Level Overview item and triggers automated emails..
d)Roles will be provided for automated emails to help move the projects along during their lifecycle.
[login to view URL]
15 freelanceri licitează în medie 290$ pentru acest proiect
Hello Dear Client, Greetings! I have analyzed your complete requirement set and I can be your go to person for this project. Why should you hire me? I am 6+ years of experience and expertise in handling complex Wor Mai multe
I am specialised in website design and development and excited for the opportunity to work with you in accomplishing your goals.. I am Good at WooCommerce, PHP, WordPress and Social Media Marketing.. Hi ! Please Sen Mai multe
Hi, I have been working on WordPress since last 8+ years. I have worked on several similar projects. You can see an example of one of those projects in my portfolio here: https://www.freelancer.com/u/aswebsmart I'm in Mai multe
Hi I am an professional Full stack software engineer with skills including Social Media Marketing, PHP, WooCommerce and WordPress etc. Very Thanks for your positing "WooCommerce, Google Spreadsheet, Dropbox [login to view URL] Mai multe
Hi There, I have read your project details. According to the details we need to read google doc details and also need to connect zapper with it. This zaps will pull the data from google sheet. I will do all these th Mai multe
Hi there!!! Yes, I can help you with crowdfunding website. As I am a Senior WordPress/Woo-commerce Designer and Developer with an experience of 8+ years and I am highly proficient at developing & customizing t Mai multe
Hello Please! Ok, I checked the project and read the details carefully, i am highly interested to work with you. Thank you for this nice project: WooCommerce, Google Spreadsheet, Dropbox [login to view URL] Integration I am Mai multe
Hi, Hope you doing well!! I go through job description in given below. I am interested in your project and can be great fit for this project. I would like to discuss more about your Project. I will serve you with Mai multe
" WooCommerce, Google Spreadsheet, Dropbox [login to view URL] Integration " Hi there, Your project seems interesting. I have few queries to ask. Are you you available to discuss them? Also, I would be glad to discuss about t Mai multe
Hi, I have reviewed your requirements for a and interested in your project i understand you'r looking for a professional degital marketer to take full responsibility of this project. With over 9 years experience wit Mai multe
Hey, Few Questions to understand problem in hand: By assests, you mean any media file? You want to create a seperate folder for each project [new google form entry]? Please elaborate 1c. For all the requirements of 2 Mai multe