![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Automating auction posting code
Apr. 26th, 2022 10:38 pmThis is the google appscript to auto publish DW posts based on data from an auction spreadsheet. Hopefully it's as user friendly as possible. It requires: copy-pasting the below code into the appropriate Google sheet's appscrit editor ("Extensions" > "Appscript"), inputting the relevant URL/username/password, running the "makeData()" function (approving the script), editing the data generated and then running the "makePosts()" function.
"makeData()" makes title, post content (including links to auto-generated bidding form and answers sheet) and tag list. "makePosts()" then creates the post and add a link to said to the reference sheet.
( my l33t code skillz let me show u them )
I should probably do a better instruction guide with pictures and things, but rn i am tired. idk, thought it might be of interest to some people. Any feedback welcome!
"makeData()" makes title, post content (including links to auto-generated bidding form and answers sheet) and tag list. "makePosts()" then creates the post and add a link to said to the reference sheet.
( my l33t code skillz let me show u them )
I should probably do a better instruction guide with pictures and things, but rn i am tired. idk, thought it might be of interest to some people. Any feedback welcome!
