Google Sheets + Schedule by Zapier + BCdiploma

Retrieve data from Google Sheets rows weekly to issue Micro-Credentials on BCdiploma and create multiple rows in Google Sheets

This Zap allows you to automatically retrieve data from specified Google Sheets rows each week and issue Micro-Credentials based on the data in BCdiploma. After issuing the Micro-Credentials, the integration automatically retrieves the data from BCdiploma and adds it back into Google Sheets rows, creating a seamless record of each action.

This Zap allows you to automatically retrieve data from specified Google Sheets rows each week and issue Micro-Credentials based on the data in BCdiploma. After issuing the Micro-Credentials, the integration automatically retrieves the data from BCdiploma and adds it back into Google Sheets rows, creating a seamless record of each action.

  1. When this happens...
    Schedule by ZapierSchedule by Zapier
    Every Week

    Triggers every week, on the day(s) selected.

    TriggerInstant
  2. automatically do this...
    Google SheetsGoogle Sheets
    Get many Spreadsheet Rows (Advanced)

    Return up to 500 rows as a single JSON value or as line items.

    ActionSearch
  3. then do this...
    BCdiplomaBCdiploma
    Issue Micro-Credentials in Batch

    Issues multiple micro-credentials at once based on the provided data set, ensuring each credential is properly generated and published in BCdiploma.

    ActionWrite
  4. then do this...
    BCdiplomaBCdiploma
    Retrieve Campaign Data

    Fetches the detailed data of a specific campaign, including links, metadata, and status, for reporting or integration into other systems.

    ActionWrite
  5. then do this!
    Google SheetsGoogle Sheets
    Create Multiple Spreadsheet Rows

    Create one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Frequency TypeRequired

    • Interval

    • Start DateRequired

    • Time of DayRequired

    Trigger
    Instant
    Try It
    • Time Offset

    • Trigger on weekends?

    Trigger
    Instant
    Try It
    • Day of the WeekRequired

    • Time of DayRequired

    Trigger
    Instant
    Try It
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Instant
    Try It
    • Time of DayRequired

    • Trigger on weekends?

    Trigger
    Instant
    Try It
    • Day of the MonthRequired

    • Time of DayRequired

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

    Trigger
    Scheduled
    Try It
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
schedule logo
schedule logo

About Schedule by Zapier

Schedule is a native Zapier app you can use for recurring tasks. Trigger an action every day of the month, every day of the week or every single day. You can also select the hour of the day. If you're a developer, this is similar to a crontab, cronjob or cron.
Learn more

Related categories

  • Scheduling & Booking
  • Zapier
bcdiploma logo
bcdiploma logo

About BCdiploma

BCdiploma is a turnkey blockchain solution for delivering tamper-proof diplomas and certificates.

Related categories

  • Education