Scheduler From Spreadsheet
Pricing
Pay per usage
Go to Store
Scheduler From Spreadsheet
Extract the schedule extraction for one or more acts.
0.0 (0)
Pricing
Pay per usage
0
Monthly users
0
Last modified
3 years ago
Dockerfile
1# This is a template for a Dockerfile used to run acts in Actor system.
2# The base image name below is set during the act build, based on user settings.
3# IMPORTANT: The base image must set a correct working directory, such as /usr/src/app or /home/user
4FROM apify/actor-node-basic:v0.21.10
5
6# Second, copy just package.json and package-lock.json since it should be
7# the only file that affects "npm install" in the next step, to speed up the build
8COPY package*.json ./
9
10# Install NPM packages, skip optional and development dependencies to
11# keep the image small. Avoid logging too much and print the dependency
12# tree for debugging
13RUN npm --quiet set progress=false \
14 && npm install --only=prod --no-optional \
15 && echo "Installed NPM packages:" \
16 && (npm list --all || true) \
17 && echo "Node.js version:" \
18 && node --version \
19 && echo "NPM version:" \
20 && npm --version
21
22# Copy source code to container
23# Do this in the last step, to have fast build if only the source code changed
24COPY . ./
25
26# NOTE: The CMD is already defined by the base image.
27# Uncomment this for local node inspector debugging:
28# CMD [ "node", "--inspect=0.0.0.0:9229", "main.js" ]package.json
1{
2 "name": "apify-project",
3 "version": "0.0.1",
4 "description": "",
5 "author": "It's not you it's me",
6 "license": "ISC",
7 "dependencies": {
8 "apify": "0.21.10",
9 "moment": "latest",
10 "request-promise": "latest"
11 },
12 "scripts": {
13 "start": "node main.js"
14 }
15}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=json
14 `;
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});Pricing
Pricing model
Pay per usageThis Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.
