Want to use a google spreadsheet to fill in blogger post info.
$30-250 USD
Closed
Posted almost 8 years ago
$30-250 USD
Paid on delivery
I want to use a Google spreadsheet to populate fields in a Blogger posts. Need someone to write the code and give me step by step instructions to get it up and running. Need to be available to walk me through if needed. This should be easy, most of the work has been done (see below). Uploaded image shows the Blogger post page with the fields I want to use.
This is what I have found online, but I can't seem to get it to work:
The Steps:
create spreadsheet in Google Drive or go to the spreadsheet created by your submission form
grab the docKey from the URL that looks like https://docs.google.com/spreadsheets/d/THE-KEY/edit#gid=0
use Row 1 in the spreadsheet to be the column headers that are used in the variables in the code. 1-word headers preferred for this example
go to File -> Publish to the Web, check "automatically republish when changes are made", and hit "start publishing"
The code example:
<script src='//[login to view URL]' type='text/javascript'/>
<script src='//[login to view URL]' type='text/javascript'/>
<script type='text/javascript'>//<![CDATA[
/**
this script was written by Confluent Forms LLC [login to view URL]
for the BlogXpertise website [login to view URL]
any updates to this script will be posted to BlogXpertise
please leave this message and give credit where credit is due!
**/
var docKey = '1Xg095tdG_9VY0b93FSh0eK52I2g6SjGg-g-pJ3u95YU'; // the docKey of your Google Docs spreadsheet
var insertAfter = '#Blog1'; // reference of object in your DOM to insert the object into
var objectType = '<div>'; // object that we'll be inserting as a container for the feed information
var objectID = 'thefeed'; // id of the object that is being inserted
var url = '[login to view URL]' + docKey +'/od6/public/values?alt=json';
$(document).ready(function(){
[login to view URL]('feeds', '1', { 'callback' : function(){
($.getJSON(url, 'callback=?')).success(function(data){
$(insertAfter).after(
$(objectType).attr('id',objectID)
);
var wrapper = $('#'+objectID);
$([login to view URL]).each(function(i,entry){
var name = [login to view URL]$name.$t;
var url = [login to view URL]$url.$t;
var type = [login to view URL]$type.$t;
var location = [login to view URL]$location.$t;
[login to view URL](
$('<ul>').append(
$('<li>').text(name)
).append(
$('<li>').text(url)
).append(
$('<li>').text(type)
).append(
$('<li>').text(location)
)
)
});
});
}});
});
//]]></script>
</head>
<body>
<div id='Blog1'>this won't be necessary in your actual implementation, placeholder for the Blog1 object</div>
</body>
</html>
Notes:
Please note that the first two lines will likely not be necessary in your template as they are likely already there. Add everything from <script type='text/javascript'>//<![CDATA[ to //]]></script> into your template, before </head>, to get it to work.
Project ID: 11010782
About the project
6 proposals
Remote project
Active 8 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
6 freelancers are bidding on average $173 USD for this job
3.5
3.5
2.5
2.5
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
About the client
Cheverly, United States
0
Member since Apr 17, 2014
Client Verification
Similar jobs
$250-750 USD
$250-750 USD
$30-250 USD
₹1500-12500 INR
$10-11 USD
₹1500-12500 INR
$30-250 USD
€8-30 EUR
€2-6 EUR / hour
₹1500-12500 INR
₹1500-12500 INR
₹1500-12500 INR
₹600-1500 INR
$30-250 CAD
$8-15 USD / hour
$10-150 CAD
$30-250 CAD
$10-30 USD
₹600-1500 INR
$10-30 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Copy to clipboard failed, please try again after adjusting your permissions.
Copied to clipboard.
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.