Scheduler From Spreadsheet
Deprecated
Pricing
Pay per usage
Go to Store
Scheduler From Spreadsheet
Deprecated
Extract the schedule extraction for one or more acts.
0.0 (0)
Pricing
Pay per usage
0
Total users
2
Monthly users
1
Runs succeeded
0%
Last modified
3 years ago
Dockerfile
# This is a template for a Dockerfile used to run acts in Actor system.# The base image name below is set during the act build, based on user settings.# IMPORTANT: The base image must set a correct working directory, such as /usr/src/app or /home/userFROM apify/actor-node-basic:v0.21.10
# Second, copy just package.json and package-lock.json since it should be# the only file that affects "npm install" in the next step, to speed up the buildCOPY package*.json ./
# Install NPM packages, skip optional and development dependencies to# keep the image small. Avoid logging too much and print the dependency# tree for debuggingRUN npm --quiet set progress=false \ && npm install --only=prod --no-optional \ && echo "Installed NPM packages:" \ && (npm list --all || true) \ && echo "Node.js version:" \ && node --version \ && echo "NPM version:" \ && npm --version
# Copy source code to container# Do this in the last step, to have fast build if only the source code changedCOPY . ./
# NOTE: The CMD is already defined by the base image.# Uncomment this for local node inspector debugging:# CMD [ "node", "--inspect=0.0.0.0:9229", "main.js" ]
package.json
{ "name": "apify-project", "version": "0.0.1", "description": "", "author": "It's not you it's me", "license": "ISC", "dependencies": { "apify": "0.21.10", "moment": "latest", "request-promise": "latest" }, "scripts": { "start": "node main.js" }}
main.js
1const Apify = require('apify');2const moment = require('moment');3const requestPromise = require('request-promise');4
5Apify.main(async () => {6 // const { sheetId } = await Apify.getValue('INPUT');7 const sheetId = '1-vpSVo1WjKheduG4YjXoOUfZ6mWaoeSekaiVRVoNV-8';8
9 if (!sheetId) {10 throw new Error('Invalid input, must be a JSON object with the "sheetId" field!');11 }12 const spreadSheetUrl = `13 https://spreadsheets.google.com/feeds/list/${sheetId}/od6/public/basic?alt=json14 `;15 console.log('Extracting info from:', spreadSheetUrl);16
17 let json;18 try {19 const response = await requestPromise(spreadSheetUrl);20 json = JSON.parse(response);21 } catch (err) {22 throw new Error('Error while getting spread sheet!', err);23 }24 const now = moment().startOf('hour');25 const afterAnHour = now.clone().add(1, 'hour');26 const defaultTime = moment().startOf('day');27
28 const { entry } = json.feed;29 const hashtags = entry.map(({ title, content }) => {30 const hashtag = title.$t;31 const [frequency] = [content.$t.match(/\d{1,2}:\d{2}:\d{2} [apm]{2}/i) || defaultTime];32 const time = moment(frequency, 'HH:mm:ss a');33 if (time.isBetween(now, afterAnHour)) {34 console.log('Calling Extractor for', hashtag);35 Apify.call('juansgaitan/instagram-extract-posts', { hashtag });36 }37 return { hashtag, time };38 });39 console.log(hashtags);40 console.log('Done.');41});