hi the script shown in the link are not the same

As soon as I linked my email to another site, this one I was immediately blocked on cloudskillsboost

How to download after link got expired and data is also deleted from phone

The account is created but it is not allow us to add chrome extension in that. Is this any solution of this?

it works only for 5 times

Try "oracle of light", the Alexa skill powered by chatGPT

Is there a way to run this script on only select labels instead of the entire inbox?

Getting Type error: rows.forEach is not a function

This is the code used in the video: function onOpen() { const ui= SpreadsheetApp.getUi(); const menu = ui.createMenu('AutoFill Docs'); menu.addItem('Create New Docs', 'createNewGoogleDocs') menu.addToUi(); } function createNewGoogleDocs(){ const googleDocTemplate = DriveApp.getFileById('your doc file id'); const destinationFolder = DriveApp.getFolderById('your drive folder id'); const sheet = SpreadsheetApp .getActiveSpreadsheet() .getSheetByName('your sheet name') const rows = sheet.getDataRange().getValues(); rows.forEach(function(row, index) { if (index === 0) return; if (row[5]) return; const copy = googleDocTemplate.makeCopy(`${row[1]}, ${row[0]}) `, destinationFolder); const doc = DocumentApp.openById(copy.getId()) const body = doc.getBody(); body.replaceText('{{Field 1}}', row[0]); body.replaceText('{{Field 2}}', row[1]); doc.saveAndClose(); const url = doc.getUrl(); sheet.getRange (index + 1, 2).setValue(url) })}

Can we use this to send more than 20k messages?

thanks

I want to extract data from more than 11000 emails...Is it possible to extract 11k extracted data in Google Sheets

Hey team, love this! How do we get this to work for labels? Would be good to be able to pull from selective labels. Or, incorporate the labels as a head then filter within google 🙏

It cannot be used for binding with certain games, but it works for a plain google sign in and KZbin account.

Blog URL: www.outrightcrm.com/blog/create-multiple-emails-with-single-gmail-account/#google_vignette

This is very helpful! Please share the whole script if possible. Thank you!

Am also one of the persons Jeyfix1 help in restoring my account that's why am here to give a shout out to him from his handle

function onOpen() { const ui = SpreadsheetApp.getUi(); const menu = ui.createMenu('AutoFill Docs'); menu.addItem('Create New Docs', 'createNewGoogleDocs'); menu.addToUi(); } function createNewGoogleDocs() { // Google Docs template file ID and destination folder ID const googleDocTemplate = DriveApp.getFileById('104gfigjCExDDZb_P8UJpC-WbF5gsEzuiBHUVcoS1Q58'); const destinationFolder = DriveApp.getFolderById('1pYBhB-Y3fL2_FfahCKKdFBtmyzoQUj8Y'); // Get the active spreadsheet and the sheet by name const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1'); // Change to your actual sheet name const rows = sheet.getDataRange().getValues(); // Get all the rows // Iterate through each row in the sheet (skipping the first row) rows.forEach(function(row, index) { if (index == 0) return; // Skip header row if (!row[0]) return; // Skip if FULLNAME is empty // Create a copy of the Google Doc template const copy = googleDocTemplate.makeCopy(`${row[0]} Employee Details`, destinationFolder); const doc = DocumentApp.openById(copy.getId()); const body = doc.getBody(); // Replace placeholders in the template with actual data from the sheet body.replaceText('{{FULLNAME}}', row[0]); // FULLNAME body.replaceText('{{REGNO}}', row[1]); // Your Address body.replaceText('{{TOPIC}}', row[2]); // TOPIC // Save and close the document doc.saveAndClose(); // Get the URL of the newly created Google Doc const url = doc.getUrl(); // Insert the document URL back into the corresponding row in column 4 (Document Link) sheet.getRange(index + 1, 4).setValue(url); // Column D (Document Link) }); }

Thank you so much. It works🎉

function checkForDubplicate() { var sheet = SpreadsheetApp.getActiveSheet(); var range = sheet.getDataRange(); var values = range.getValue(); var newRow = sheet.getActiveRange().getRow(); var newCol = sheet.getActiveRange().getColumn(); var newValue = sheet.getActiveRange().getValue().toString().toLowerCase(); var duplicateCells = []; for (var row = 0; row < values.length; row++){ for (var col =0; col <values[row].length; col++){ if (values[row][col].toString().toLowerCase() === newValue && (row+1) != newRow && (col+1) != newCol){ var dubplicateRow = row+1; var dubplicateCol = col+1; duplicateCells.push(String.fromCharCode(64+dubplicateCol)+dubplicateRow); } } } if (duplicateCells.length>0){ var response = Browser("Dubplicate Record Found", "The Conumser Number '" + sheet.getActiveRange().getValue() + "' already exists in the following cells: " + duplicateCells.join(", ") + ". Do you still want to add it?", Browser.Buttons.YES_NO); if ( response == "no"){ sheet.getRange(newRow, newCol).clearContent; } if ( response == "yes") { sheet.getRange(newRow, newCol).clearContent; } } }

Please grant access for the script, thank you!

@lG I msg Jeyfix1 whose name is all over the comment section,I was in doubt about him at first but then he proved himself to be legit I thought it’s not gonna be possible to get a deleted account back but surprisingly he did I can now vouch for him

Thank you for the concise review. This is a powerful tool and you really helped me a lot. Please send the access so that I can deploy in my business.

Thanks a lot

it almost gave me some hope but then i saw limited access to other websites , i can't signup to heygen ai

this works, thank you so much!!

I cant get any Codes from this emaisl

I thought the whole comment about Jeyfix1 are bot,but I was wrong he's legit I recommend him

Thanks Ho Gaya

Did this and my accounts got suspended for google cloud

Well I'm back here to appreciate jeyfix1 for his good works,hes honestly doing a good job helping people get back their account,just visit his page and confirm from your self

Can you pls share the script ?

is it temporary account or permanent

can we use it?

Love your voice! You should make a AI voice!😊

i need access to the script please

hello I just wrote to you because the problem is that it doesn't work for me

I requested access to the script,

Good to know. Thank you.

Execution was completed successfully but when I tried to create new docs, it did not generate a new document or a link

Thanks

how can copy a image on a cell (sheet) to the Doc template?

Hi! Is the link to the script available is not working for me. Kindly Help Please

Awesome videos!! just waiting for access, I sent out the approval request.

thank you, I appreciate a lot! 🇻🇳 <3

Just requested for the script, this is a great solution guys. Well done at Outright!!

Thanks for solved my biggest problem

Thanks for the AppScipt code

This is informative, I need access